MySQL Forums
Forum List  »  Full-Text Search

How much table size effect on fulltext search
Posted by: himanshu sharma
Date: April 25, 2008 12:05AM

Hi All,

I am Himanshu and since last few days i am facing problem in fulltext search. Perviously i have worked on Fulltext search in my pervious project successfully.

But now i facing problem with fulltext search. My problem is my table size is more than 15GB and total records size only 20 lacs. I have implement fulltext for fast searching i have created two composite fulltext index. Both index contain 3 fields.

But when i am going for search and use both of the index (use Two Match) my query will take more than 8 to 10 sec and some it will hang the system.
Or when i use only one index then also it will take more then 5 sec. In both of these condition i have not use any other where condition and also not use any ordering.
I am just using simple fulltext search query.

I have also read about database partitioning but it is not solution. So please giude me what should i do.

Is this a problem of table size or index size. if yes then How much table size will effect on fulltext searching.

what is the limit of table and idex size for fulltext in mysql. One more thing i am using mysql 5.0,

should i go for spitting table or reducing table size? Please give some solution.

Thanks in advance,
Himanshu Sharma

Options: ReplyQuote

Written By
How much table size effect on fulltext search
April 25, 2008 12:05AM

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.