Re: Up to 1 million rows Performance + Design Help
Sorry i didn't undestand if Mysql will use the multi index by gener_id, movie_date when checks the movie table?
What i want is to use fulltext index and order the results using index too. If the keywords are in the movie table this is impossible, because Mysql will always use fulltext index and then do more work to sort the result. BUT if the keywords are in separate table, what? If it will use the multi index to get them ordered.
Subject
Written By
Posted
February 05, 2009 05:24PM
February 06, 2009 12:46AM
Re: Up to 1 million rows Performance + Design Help
May 18, 2009 09:49AM
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.