| 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.0 | Jorge Bastos | 5 Nov |
| • Re: Fw: MySql4.1.15 Vs MySql5.0 | Leo G. Divinagracia III | 11 Nov |