Re: [sqlite] Between And statement too much slow

2008-09-20 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: > The EXPLAIN QUERY PLAN keyword works, and I love it, but it's > completely undocumented. How come? http://www.sqlite.org/cvstrac/wiki?p=QueryPlans Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux)

Re: [sqlite] Between And statement too much slow

2008-09-20 Thread seun . osewa
The EXPLAIN QUERY PLAN keyword works, and I love it, but it's completely undocumented. How come? On 9/19/08, Stephen Oberholtzer <[EMAIL PROTECTED]> wrote: > On Fri, Sep 19, 2008 at 12:36 PM, Giuseppe Costanzi > <[EMAIL PROTECTED]>wrote: > >> >> How could improve my code? > > > Go into the

Re: [sqlite] Between And statement too much slow

2008-09-19 Thread Igor Tandetnik
Giuseppe Costanzi <[EMAIL PROTECTED]> wrote: > the query look on 16750 record on tblTansactions and return 85 rows > > > sSQL ="""SELECT > tblProducts.ProductName,tblProducts.WarehouseCode,tblProducts.UnitsInStock,SUM(tblTransactions.Quantity) > FROM tblProducts >

Re: [sqlite] Between And statement too much slow

2008-09-19 Thread Stephen Oberholtzer
On Fri, Sep 19, 2008 at 12:36 PM, Giuseppe Costanzi <[EMAIL PROTECTED]>wrote: > > How could improve my code? Go into the sqlite3 command line and issue EXPLAIN QUERY PLAN You'll have to fill in some values for the ?s, but that'll give you some hints. Also: How long is "too slow"? Several

[sqlite] Between And statement too much slow

2008-09-19 Thread Giuseppe Costanzi
Hi, I'm using this query on my aplication to retrive a recordset that shows transactions between two date. The problem is that it's too much slow. I'm using python and the field TransactionDate is Datetime (e.g. 2008-01-01) and i passed some such parameters ('1', datetime.date(2008, 7, 1),