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

• Next in forum: Re: !Need advice from other PHP developers.
• Prev in forum: Re: capture images remotely with PHP
• Thread view: Re: Best text search for many Gigabyte Database?

[Reply to this message]