----- Original Message ----- From: "David Bordas" <[EMAIL PROTECTED]> To: "Mikhail Entaltsev" <[EMAIL PROTECTED]> Sent: Tuesday, August 27, 2002 4:55 PM Subject: Re: Slow select query, need some clues to speed it up please ...
> ME> :( That's strange. You removed condition (which can only _increase_ > number > ME> of records in resultset) > ME> and query works much slower... > ME> May be occasionally anybody run another big query in parallel? in other > case > ME> I have no idea... :( > > Yep i think too that anybody run another big query in parallel. In this case... Can you try again? SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable WHERE Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%') ORDER BY Field6 LIMIT 0,20; IMHO there are 2 ways: 1. It will work much faster. 2. It won't change speed of execution significantly. Mikhail. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
