On 6/7/07, Cory Robin <[EMAIL PROTECTED]> wrote:
The issue I have is that the ratio of queries on old vs.
new data is like 1:100000.   And searches would be MUCH
faster if I could force my queries that are looking at
current or future data to use an index that ONLY had that
information in them..

You might want to look at partition pruning in MySQL 5.1.

- Perrin

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to