Re: Up to 1 million rows Performance + Design Help
Rick i have a question, if he separates the text columns(that eventually will be used for fulltext search) in table movie_keywords and separate the genres in other table geners, and puts gener_id in the movies table. How will be performed search by keyword + gener Mystery?
If he join the 2 tables.
select <fileds> from moves m, movie_keyword mk where m.move_id = mk.move_id and
MATCH(mk.keywords) AGAINST(...) and m.gener_id = 3 order by move_date limit 200, 24;
if there are index INDEX on gener_id, move_date on movies
is the query use fulltext for the first table and the INDEX from the moves table? :)
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 05:18AM
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.