469,594 Members | 2,106 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,594 developers. It's quick & easy.

FullText index performance issue

Hi, I'm running a fulltext query on a ~50000 record mysql database and
while performance is usually satisfying - about 0.02 secs per query, i
get a critical performance deterioration when looking for popular
keywords (words that appear in more than 50% of the data) - about 0.25
secs/query. I know that the standard fulltext engine does not return
any results on such words, and this is good, but this does not explain
the performance issue. Any ideas?

Sep 12 '05 #1
0 1105

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Matt W | last post: by
reply views Thread by Phil Powell | last post: by
reply views Thread by steve | last post: by
reply views Thread by Alex Glass | last post: by
reply views Thread by Robert Oschler | last post: by
1 post views Thread by Robert Oschler | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.