[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-win32
Subject:    Re: Fw: MySql4.1.15 Vs MySql5.0
From:       "Leo G. Divinagracia III" <leo.divinagraciaiii () csueastbay ! edu>
Date:       2005-11-11 22:02:38
Message-ID: 437514FE.6030100 () csueastbay ! edu
[Download RAW message or body]

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@csueastbay.edu


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32?unsub=mysql-win32@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]