3 messages in com.mysql.lists.win32Re: Fw: MySql4.1.15 Vs MySql5.0
FromSent OnAttachments
Ilavajuthy Palanisamy04 Nov 2005 15:47 
Jorge Bastos04 Nov 2005 15:56 
Leo G. Divinagracia III11 Nov 2005 14:02 
Subject:Re: Fw: MySql4.1.15 Vs MySql5.0
From:Leo G. Divinagracia III (leo.@csueastbay.edu)
Date:11/11/2005 02:02:16 PM
List:com.mysql.lists.win32

Jorge Bastos wrote:

Does the table has promary keys and index's ?

that's what i was thinking too. first time i worked with a rather large DB (about 500-700k records), queries would take 20 seconds.

someone pointed me to the EXPLAIN command and i found out it was going through all the rows... yikes! apparently, i missed indexing a column...

inserted a new index and BAM! 2-3 seconds... and searches were going less then 100-300 rows...

-- Leo G. Divinagracia III leo.@csueastbay.edu