Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

Fulltext search with order by static field [message #283] Tue, 24 October 2006 02:32  al.james Messages: 15 Registered: October 2006 Junior Member Hi there... I need to optimise: SELECT * FROM table WHERE MATCH(text_field) AGAINST ('text') ORDER BY score DESC; where score is a pre-computed int field. At the moment, despite text_field and score both having indices, the query results in a filescan. I guess as mysql will only use one index per table, it is using the fulltext index. Is there anything that can be done to speed this up? thanks Alastair James Report message to a moderator

	Fulltext search with order by static field By: al.james on Tue, 24 October 2006 02:32
	Re: Fulltext search with order by static field By: bluesaga on Mon, 25 December 2006 20:42
	Re: Fulltext search with order by static field By: Peter on Wed, 10 January 2007 11:31
	Re: Fulltext search with order by static field By: albion on Mon, 20 August 2007 00:10

Previous Topic:	Setup Sphinx
Next Topic:	fulltext search with additional condition in the where clause

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]