In the last episode (Aug 09), Vinod Bhaskar said:
> I have MySQL 3.23.41 in my Mandrake Linux 8.1. I am using PHP 4.0
> queries to access the MySQL database, in Apache 1.3.2 environment.
>
> Now a days, some of my php modules are very slow. eg., earlier a
> report generation program in PHP use to take less than 30 sec to
> genrate and disply the report and noiw the same report program is
> taking more than 5 min to disply. Off couce the database is growing.
> But there are only 4000 Records.
>
> What may be the problem and how to spead up the process? Please suggest.
You probably need to add indexes. Chapter 5 of the MySQL manual
explains it all.
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html
--
Dan Nelson
dnelson@stripped
