Hi,
----- Original Message ----- From: "Shashank Tripathi" <[EMAIL PROTECTED]> To: "'David Bordas'" <[EMAIL PROTECTED]>; "'BRACHET,STEPHAN (Non-HP-France,ex1)'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, August 28, 2002 12:25 PM Subject: RE: Slow select query, need some clues to speed it up please ... > What do you mean "varchar and text fields are not index"? > > alter table mytable add index (myvarchar, mytext(100)) ...or one index for many fields. > > One last resort that may work for you is to try the regexp instead of > LIKE. The functionality of regexps for me has at best been > unpredictable, sometimes it is faster, sometimes at par with LIKEs. ...yea....right. > > So, > > " where CONTENT like '%word1%' > or CONTENT like '%word2%' > or CONTENT like '%word3%' " ...and you have good results, using bitwise operator? > > becomes, > > " where CONTENT regexp 'word1|word2|word3' " > .....anyway this is not the same with the David problem. Regards, Gelu > > Cheers > Shanx > > > > | Yep i do that but varchar and text fields aren't index so ... > | > | I'm also having a look to FULLTEXT index, but i think > | that the index will be really really big ... :( > | > > > Shashank Tripathi > www.shanx.com > > > Sql, query > > > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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
