|
|
Posted by ngocviet on 02/05/07 10:05
> 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.
I've tried FULLTEXT but it take too long, about over 10 seconds with
1.2 Gigabyte table.
If need, I can convert database to other structure.
Navigation:
[Reply to this message]
|