Hi Reindl, Thanks for your quick answer, but i think the engine is MySAM but I'm not sure, What type of index recomendais me, unique, full-text, etc..? Thanks a lot
2011/12/4 Reindl Harald <h.rei...@thelounge.net> > > > Am 04.12.2011 20:25, schrieb Rafael Valenzuela: > > Hi all, > > In one query, I am comparing a string with a 'like=%patron%', but is > very > > slow and expensive .What is the best way to compare a string? like or > > regular expression? > > The data base is too big table 1TB, any idea? > > thanks a lot > > http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html > > without indexes is big tables is no fast search possible > if you are useing innodb you have currently lost > > -- Mit forever My Blog <http://www.redcloverbi.wordpress.com> My Faborite Web<http://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm> http://www.technologyreview.com/
