-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)
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
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
>
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
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),
5 matches
Mail list logo