Re: Arbitrary amount of BETWEENs
From: dee <buhhko_at_gmail.com>
Date: Tue, 29 Apr 2008 18:09:22 -0700 (PDT)
Message-ID: <1cce6d01-a409-4bec-9fc0-6ec1f2d9fd21@l42g2000hsc.googlegroups.com>
Date: Tue, 29 Apr 2008 18:09:22 -0700 (PDT)
Message-ID: <1cce6d01-a409-4bec-9fc0-6ec1f2d9fd21@l42g2000hsc.googlegroups.com>
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?
Received on Tue Apr 29 2008 - 20:09:22 CDT