Posted by Erwin Moller on 02/05/07 08:47

ngocviet wrote:

> I have a so big DB, It's about 10-100GB of text.
> Now I want to create a searching function but It take too long when I
> use LIKE from MySQL
> Anyone know the best sollution?
> Can I use Google Desktop search or an others?
> Please help!

If you use mySQL, consider using FULLTEXT and MATCH AGAINST().
Bottomline stays: If you have 100GB of data, some searchtime is needed, but
using FULLTEXT can speed that up considerable.
Check your mySQL documentation for details.

Regards,
Erwin Moller

[Back to original message]