As I understand... After removing "Field5 LIKE '%John'" condition the query works much faster. But it is different query... :) I mean that queries return different results. On other hand you can't change type of Field5 because you have a row with 51723 symbols in Filed5. :( So... question: Do you actually need this condition? ;)
Best regards, Mikhail. ----- Original Message ----- From: "David Bordas" <[EMAIL PROTECTED]> To: "Mikhail Entaltsev" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, August 27, 2002 3:31 PM Subject: Re: Slow select query, need some clues to speed it up please ... > From: "Mikhail Entaltsev" <[EMAIL PROTECTED]> > > ME> IMHO the problem is in this condition > ME> ...Field5 LIKE '%John'... > > > ME> Can you remove it from query and try again? > > In fact it was Field5 LIKE '%John%', > but "Field5 LIKE '%John'" and "Field5 LIKE '%John%'" don't change query > speed at all except about 0.01s .. > > I try remove it and i was surprised, speed grow and do not decrease. > Perhaps because mysql has to analyse more rows before to have enough rows > ... > > 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