Re: Partition on day of year

[Brian Wilson]

First, thanks for your help! Second, a few things to note:

1. I'm using MyISAM (should I not?)
2. The customer_id is almost always going to be = 1
3. Using my current index (customer_id`,`job_date_time`,`printer_name`,`username`) I get results in under 1 second when doing:

SELECT * FROM test_jobs WHERE customer_id = 1 AND job_date_time BETWEEN '2011-01-02 00:00:00' AND '2011-01-02 23:59:59' ORDER BY job_date_time LIMIT 0,25;

But adding the LIKE statements for printer_name and username slow things down to 30 seconds or so. Which seems odd. It's doing the pruning to the right partition...