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
>
> What exactly does this mean? Are you running the exact same query
> several times (if so, why?), or similar queries with different
> parameters? How much different is the time between runs? Why is this a
> problem in the first place?
>
> Igor Tandetnik
>
> Thanks for your reply, yes we are running the same query with the same
> parametes only. The execution time gets differed for us when we tested for
> the two different times so we tested the application with the same
> location where the query gets called and found that the different
> execution takes different time. and the execution time varies between 38
> secs for one time and 54 secs for the second time. Yes this problem is
> related to the performance so we are concerned about this.
>
> Regards,
> kartthi.
>
>
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://www.nabble.com/Query-Execution-in-SQLite-tp17748185p17754963.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