MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Slow query if using arithmetic (+1) in Where Clause
Posted by: KimSeong Loh
Date: December 31, 2005 07:53PM

Maybe you want to post the result of the EXPLAIN.

My guess is that the extra condition made it more restrictive, so may need to read more rows to get the first 250 rows in the result. Tests without LIMIT may gives you a fairer comparison if the LIMIT restricts the results of the SELECT based on your data.

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


Subject
Views
Written By
Posted
Slow query if using arithmetic (+1) in Where Clause
3201
Ran Geva
December 31, 2005 06:11AM
Re: Slow query if using arithmetic (+1) in Where Clause
1414
KimSeong Loh
December 31, 2005 07:53PM
Re: Slow query if using arithmetic (+1) in Where Clause
1416
Ran Geva
January 01, 2006 03:40AM
Re: Slow query if using arithmetic (+1) in Where Clause
1583
KimSeong Loh
January 01, 2006 08:01AM
Re: Slow query if using arithmetic (+1) in Where Clause
1405
Ran Geva
January 01, 2006 09:22AM
Re: Slow query if using arithmetic (+1) in Where Clause
1796
KimSeong Loh
January 01, 2006 07:42PM


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.