Re: Fulltext search with order by using filesort
Posted by:
Brian Moon
Date: January 01, 2006 12:19PM
I will tell you how we do it in Phorum. We create a temp table that contains the message id and datestamp (with a key on datestamp) of the message from the FullText results. We then select on that temp table for the sorting.
Brian Moon
Phorum Dev Team
http://phorum.org/
-----------------------
dealnews.com - How to go broke saving money.
http://dealnews.com/
Subject
Views
Written By
Posted
4729
December 30, 2005 12:37PM
Re: Fulltext search with order by using filesort
2695
January 01, 2006 12:19PM
2979
January 02, 2006 12:20PM
2286
January 02, 2006 06:08AM
2243
January 02, 2006 12:25PM
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.