> > As I understand... > > After removing "Field5 LIKE '%John'" condition the query works much > faster. > Nop, sorry i'm not clear, the query works mush slower ...
:( That's strange. You removed condition (which can only _increase_ number of records in resultset) and query works much slower... May be occasionally anybody run another big query in parallel? in other case I have no idea... :( Mikhail. ----- Original Message ----- From: "David Bordas" <[EMAIL PROTECTED]> To: "Mikhail Entaltsev" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, August 27, 2002 4:28 PM Subject: Re: Slow select query, need some clues to speed it up please ... > From: "Mikhail Entaltsev" <[EMAIL PROTECTED]> > > > As I understand... > > After removing "Field5 LIKE '%John'" condition the query works much > faster. > Nop, sorry i'm not clear, the query works mush slower ... > > > But it is different query... :) > > I mean that queries return different results. > Yep ... > > > On other hand you can't change type of Field5 because you have a row with > > 51723 symbols in Filed5. :( > I know that and that's a problem ... > > > So... > > question: Do you actually need this condition? ;) > > I need it yes, but i'm thinking about doing 2 or 3 queries or modify some > code of my app about this search ... > > 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