----- Original Message ----- From: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]>
DB> SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable WHERE DB> Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%' OR DB> Field5 LIKE '%John') ORDER BY Field6 LIMIT 0,20; DWP> have you try to remove the ORDER BY Field6 ? and compare the query time ? Yes but don't change anything in most of case. Best i can do without the order by is 0.01s less than with ... Thanks David --------------------------------------------------------------------- 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