Re: [sqlite] Query Execution in SQLite

2008-06-10 Thread sqlite
Igor Tandetnik wrote: > > "sqlite" <[EMAIL PROTECTED]> wrote > in message news:[EMAIL PROTECTED] >> 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 > >

Re: [sqlite] Query Execution in SQLite

2008-06-10 Thread Igor Tandetnik
"sqlite" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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 What exactly does this mean? Are you ru

[sqlite] Query Execution in SQLite

2008-06-09 Thread sqlite
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