MySQL Forums
Forum List  »  Full-Text Search

Fulltext Search far too slow
Posted by: Ben Prins
Date: March 13, 2006 05:42AM

Hi Guyz,

I have got the following problem:

MySQL-table with ~7800000 datasets, tablesize ~10GB.
The table contains articles stored as text.
I would like to have a fast fulltext-search with a query like this:

Query: SELECT ID FROM articles WHERE MATCH (title, abstract) AGAINST ('STRING');

I have created a Fulltext-Index of course. But the search is still painfully slow.
(~30seconds up to several minutes)

Box: P4 2,4 Ghz , RAM: 1GB, HD: 160GB Sams. IDE, OS: Linux


Do you guys have any ideas ? What I am doing wrong ?

Options: ReplyQuote

Written By
Fulltext Search far too slow
March 13, 2006 05:42AM
March 14, 2006 10:11AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.