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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
