List:MySQL on Win32« Previous MessageNext Message »
From:Leo G. Divinagracia III Date:November 11 2005 10:02pm
Subject:Re: Fw: MySql4.1.15 Vs MySql5.0
View as plain text  
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.divinagraciaiii@stripped

Thread
Fw: MySql4.1.15 Vs MySql5.0Jorge Bastos5 Nov
  • Re: Fw: MySql4.1.15 Vs MySql5.0Leo G. Divinagracia III11 Nov