Re: Arbitrary amount of BETWEENs

From: <>
Date: Tue, 29 Apr 2008 19:02:40 -0700 (PDT)
Message-ID: <>

On Apr 30, 11:09 am, dee <> 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.

  • Phil
Received on Tue Apr 29 2008 - 21:02:40 CDT

Original text of this message