How much table size effect on fulltext search

[himanshu sharma]

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