Have you tried adding force index on your fulltext index?
Something similar to this:
select field1,field2,field3 from table FORCE INDEX(index2)
where field1='something'
and field2='something_else'
and field3='something_more'
and match(field4) against ('word1 word2' in boolean mode)
order by field1,field2,field3
Regards,
Mike Hillyer
www.vbmysql.com
-----Original Message-----
From: H M Kunzmann [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:33 AM
To: [EMAIL PROTECTED]
Subject: fulltext searching and query order question
Hi all.
I have a fulltext index on a table.
If I have the following fields:
field1,field2,field3,field4
Field4 being the fulltext field.
I have the following indices:
index1->field1,field2,field3
index2->fulltext field4
If I do a select:
select * from table where match(index2)
against ('word1 word2' in boolean mode);
I get a very fast result.
Essentially I want to do the following:
If I do a select field1,field2,field3 from table
where field1='something'
and field2='something_else'
and field3='something_more'
and match(field4) against ('word1 word2' in boolean mode)
order by field1,field2,field3
I can't seem to get it right that the query can return
quickly, as it does a table scan to sort the table,
which takes forever.
How do I get a fulltext search to be able to sort according
to a different field ???
Thanks for all assistance :-)
Regards,
Herbert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
