|
|
Posted by Kimmo Laine on 02/05/07 10:56
"ngocviet" <ngocviet@gmail.com> wrote in message
news:1170669914.799189.11620@h3g2000cwc.googlegroups.com...
>
>> 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.
A search like that for such an amount of unindexed textual data simply has
to take some time. Live with it, or invest to hardware. Like the IT proverb
says: "If it doesn't work, just throw money at it".
--
"Ohjelmoija on organismi joka muuttaa kofeiinia koodiksi" - lpk
http://outolempi.net/ahdistus/ - Satunnaisesti pδivittyvδ nettisarjis
spam@outolempi.net | rot13(xvzzb@bhgbyrzcv.arg)
[Back to original message]
|