Re: [sqlite] Faster query result

2013-02-22 Thread jose isaias cabrera
"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

Re: [sqlite] Faster query result

2013-02-22 Thread Cory Nelson
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)'; >

Re: [sqlite] Faster query result

2013-02-22 Thread Etienne
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

Re: [sqlite] Faster query result

2013-02-22 Thread Igor Tandetnik
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

[sqlite] Faster query result

2013-02-22 Thread jose isaias cabrera
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é ___