Dear All, We are using SQLite for our application development which would be deployed in a pocket pc.Here we are using a inner join query which takes different time during different executions, the query which we using in our application is
"SELECT DISTINCT MT.PcNo, MT.SubPcNo, MT.BrandNo, MT.BrandDescription, MT.ST, MT.TS FROM Brand MT INNER JOIN ProdSubPcControlLink PSCL ON MT.PcNo = PSCL.PcNo AND MT.SubPcNo = PSCL.SubPcNo INNER JOIN ShopControlLink SCL ON SCL.TripCode = PSCL.TripCode AND SCL.AuditClassNo = PSCL.AuditClassNo INNER JOIN OptimumControlLink OCL ON OCL.TripCode = SCL.TripCode AND OCL.AuditClassNo = SCL.AuditClassNo AND OCL.ShopSetCode = SCL.ShopSetCode AND OCL.PcSetCode = PSCL.PcSetCode WHERE PSCL.TripCode = 119 AND PSCL.AuditClassNo = 1 AND SCL.ShopCode = 26 LIMIT 200" Kindly let us know why this kind of behaviour is happening to solve this issue. Regards, kartthi -- View this message in context: http://www.nabble.com/Query-Execution-in-SQLite-tp17748185p17748185.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
