From: Dan Nelson
Date: August 9 2003 5:07am
Subject: Re: How to speed up the access
List-Archive: http://lists.mysql.com/mysql/147297
Message-Id: <20030809050734.GC96076@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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