Re: Arbitrary amount of BETWEENs

From: <phil_herring_at_yahoo.com.au>
Date: Tue, 29 Apr 2008 19:02:40 -0700 (PDT)
Message-ID: <350a86c2-5964-481e-ab3e-7cc301036315@x19g2000prg.googlegroups.com>


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.

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

Original text of this message