On Mon, 25 Aug 2003 10:05:32 +0530 (IST) "Rupak Banerjee" <[EMAIL PROTECTED]> wrote:
> > Hi, > I have a mysql database running on Mysql version 3.23.53 on a Red Hat > Linux 7.2. In the database there is a single table with over 150,000 > records. Unfortunately, the performance of that table is very poor, > comparing to other tables in the same database. > Can somebody help me out. > Thanks, > Rupak Banerjee. read about query optimization and table indexes. use EXPLAIN SELECT .. to see what happends with your query. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]