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
ft_buffer_size=512M
Do you guys have any ideas ? What I am doing wrong ?
Subject
Views
Written By
Posted
Fulltext Search far too slow
3971
March 13, 2006 05:42AM
2390
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.