Performance issue (MySQL and PHP)

[php.dudette]

help!!!
The data stored in the database (MySQL) has run into more than 1 lakh tuples. Because of this my applications (PHP) are running very slow.
Any way i can speedup the performance?

Thanx !!!

:)

[Sheldon]

What is a "lakh tuples"?

How much are yo storing?

Try posting an example of the PHP which is running very slow

[php.dudette]

1. a lakh tuples means a lakh records(rows).

2. my query is simply calculating sum of all numbers of a field.

3. example: comparing number of electricity units consumed each month (Jan till Dec) for year 1999 and 2000 in a certain area.

select sum(e_units) from table_name where t_date like '$year-$month-%' where area='area1';

a) month is taken from an array.
b) year is selected by the user.
c) Area is selected by the user.

[chazzy]

build an index on the columns t_date and area. this should significantly improve performance.

also, this should go in the SQL or PHP forums...

[php.dudette]

Thank you.