From: Reindl Harald
Date: December 4 2011 8:50pm
Subject: Re: the best way compare String
List-Archive: http://lists.mysql.com/mysql/226443
Message-Id: <4EDBDD1A.7070109@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigF4343F292C37CE5302EE0E7E"

--------------enigF4343F292C37CE5302EE0E7E
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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
>=20
> 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=3D%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


--------------enigF4343F292C37CE5302EE0E7E
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk7b3RoACgkQhmBjz394Anna0wCbBZAeMOqST9ViV9ogUQu7THFK
ny0Ani7OSAf2Sr1Gk+wczrZ+FNozjnVk
=k8ih
-----END PGP SIGNATURE-----

--------------enigF4343F292C37CE5302EE0E7E--