Re: Arbitrary amount of BETWEENs
Date: Tue, 29 Apr 2008 19:02:40 -0700 (PDT)
On Apr 30, 11:09 am, dee <buh..._at_gmail.com> wrote:
> Well.. It does the trick but unfortunately this statement has a huge
> severe impact on performance itself probably due to the cartesian join
> (100ms vs 30s). Worth mentioning is that the table at present time
> contains more than 6.000.000 rows and growing. But thanks though for a
> detailed example :) Any other suggestions?
I suggest you won't last in this line of work if you give up that easily.
With very little effort, and on a table with 32 million rows, I got it down to under 2s with 30 pairs of dates. I could probably make it faster.
Read up on performance tuning.