you THINK the engine is? WTF?
fulltext if you need fulltext-search
please read the manuals i linked!
Am 04.12.2011 21:20, schrieb Rafael Valenzuela:
> 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.reindl@stripped>
>> 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
>>> 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
>> without indexes is big tables is no fast search possible
>> if you are useing innodb you have currently lost
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc