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