Re: Some fulltext queries hang miserably
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...
Subject
Views
Written By
Posted
3366
April 26, 2006 07:35PM
2059
May 02, 2006 12:09PM
2310
May 02, 2006 01:12PM
Re: Some fulltext queries hang miserably
2669
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.