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
>                     INNER JOIN tblTransactions ON
> tblProducts.ProductID=tblTransactions.ProductID
>                     WHERE tblTransactions.TransactionType = 0
>                     AND tblProducts.WarehouseID = ?
>                     AND tblTransactions.TransactionDate BETWEEN ? AND
>                     ? GROUP BY tblProducts.ProductID
>                     ORDER BY tblProducts.ProductName"""
>

Try creating an index on tblTransactions(ProductID, TransactionDate)

Igor Tandetnik



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to