Re: Perl and MySQL woes

This is really a MySQL question.

I suggest you ask MySQL to explain both queries and see how they differ. My guess is that the one using IN is using an index for each of the dates you give it, and the other one is doing a scan of some kind.

Comment on Re: Perl and MySQL woes Download Code

Replies are listed 'Best First'.
Re^2: Perl and MySQL woes by cosmicperl (Chaplain) on Jan 13, 2008 at 03:53 UTC
I only tend to code Perl so I guess I'm too used to coming here with my questions. My bad	[reply]
Re^3: Perl and MySQL woes by ysth (Canon) on Jan 13, 2008 at 07:15 UTC
What does explain show? Can you show the old and new table definitions, including keys? -- CollegeGear.com - more than just college gear (though, yes, we have college-branded teddy bears)	[reply]