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]