MySQL Forums
Forum List  »  Knowledge Base

Large data question
Posted by: Tim Smith
Date: December 04, 2008 01:53AM


I have a large dataset (5mil + records).

I am using a MATCH AGAINST syntax to query the data within a stored procedure.

Also, within that stored procedure I am using SQL_CALC_FOUND_ROWS and FOUND_ROWS() also to get the total number of records returned.

My question is that if I use a new term to search against my indexed fulltext keys, the query is initially slow(ish) afyer that, however, any subsequent calls are quick.

Is this the way the index works? It will store what has been queried in the past and make this readily available (in the key buffer cache?)

Is there any way to make my queries quick from the outset.

The table type I am using by the way is MyISAM.

Thanks in advance.


Options: ReplyQuote

Written By
Large data question
December 04, 2008 01:53AM
December 06, 2008 10:23PM

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.