MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Close to a million records & query too slow
Posted by: sabelo simelane
Date: March 08, 2010 03:36PM

Rick, you're a genius man! This query was running for 1 min 0.76 sec and now it runs for only 0.04 sec. It's unbelievable what my ignorance was costing me!

Again, thank you Rick, I do appreciate your assistance.

--
Sabelo

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Close to a million records & query too slow
6513
sabelo simelane
March 03, 2010 01:49PM
Re: Close to a million records & query too slow
2587
Rick James
March 04, 2010 10:09PM
Re: Close to a million records & query too slow
2363
sabelo simelane
March 08, 2010 03:36PM
Re: Close to a million records & query too slow
2018
sabelo simelane
March 08, 2010 04:12PM
Re: Close to a million records & query too slow
2451
Rick James
March 09, 2010 09:20PM
Re: Close to a million records & query too slow
2031
sabelo simelane
March 11, 2010 01:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.