MySQL Forums
Forum List  »  Full-Text Search

Re: Some fulltext queries hang miserably
Posted by: Robot Machine
Date: May 03, 2006 06:36AM

Well, I already limit the result set to 100. We're not talking about unusually large tables here; topics_search is 10.5 k rows (subject is VARCHAR(255)) and posts_search is 147.7 k rows (message is TEXT). I fully realize that the data may someday outgrow mysql's FULLTEXT capabilities, but I don't suspect that to be the case since most of the time this search script executes in a very timely manner. It may be one query in 4k or 5k similar queries that blows up.

I am rather suspecting that this bug is related to my problem:
http://bugs.mysql.com/bug.php?id=16893

Upgrading to mysql 5.0 is a possibility since the bug is fixed in that version, but I'm not really sure of what caveats are involved in upgrading to the next major release...

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Some fulltext queries hang miserably
2547
May 03, 2006 06:36AM


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.