"Cory Nelson" and the whole list wanted to know...
On Fri, Feb 22, 2013 at 9:56 AM, jose isaias cabrera wrote:
Greetings.
which one is faster...
#1.
SELECT id FROM LSOpenJobs WHERE bdate BETWEEN '2012-01-01' AND
'2012-12-31';
or this one...
#2
SELECT id FROM LSOpenJobs WHERE bdate IN
On Fri, Feb 22, 2013 at 9:56 AM, jose isaias cabrera
wrote:
>
> Greetings.
>
> which one is faster...
>
> #1.
>
> SELECT id FROM LSOpenJobs WHERE bdate BETWEEN '2012-01-01' AND '2012-12-31';
>
> or this one...
>
> #2
>
> SELECT id FROM LSOpenJobs WHERE bdate IN ('2012-01-01', ..., '2012-12-31)';
>
Hello José,
#1: no hash/bsearch required.
Regards,
Etienne
- Original message -
From: jose isaias cabrera
To: General Discussion of SQLite Database
Subject: [sqlite] Faster query result
Date: Fri, 22 Feb 2013 10:56:08 -0500
Greetings.
which one is faster...
#1.
SELECT id FROM
On 2/22/2013 10:56 AM, jose isaias cabrera wrote:
which one is faster...
#1.
SELECT id FROM LSOpenJobs WHERE bdate BETWEEN '2012-01-01' AND '2012-12-31';
or this one...
#2
SELECT id FROM LSOpenJobs WHERE bdate IN ('2012-01-01', ..., '2012-12-31)';
where , ..., would have all the rest of the
Greetings.
which one is faster...
#1.
SELECT id FROM LSOpenJobs WHERE bdate BETWEEN '2012-01-01' AND '2012-12-31';
or this one...
#2
SELECT id FROM LSOpenJobs WHERE bdate IN ('2012-01-01', ..., '2012-12-31)';
where , ..., would have all the rest of the dates. Thanks.
josé
___
5 matches
Mail list logo