Re: [sqlite] Selection Time

2006-11-29 Thread John Stanton 

Lloyd wrote:

Hi,
  How much time can it take to perform 2000 selection queries on the
same database ?  Mostly the result set will contain only 1 raw. Is there
is any way to improve the selection speed?

Thanks,
  Lloyd


__
Scanned and protected by Email scanner

-
To unsubscribe, send email to [EMAIL PROTECTED]
-


Run a trial and measure it and experiment with indioes.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Selection Time

2006-11-29 Thread P Kishor 

On 11/30/06, Lloyd <[EMAIL PROTECTED]> wrote:

Hi,
  How much time can it take to perform 2000 selection queries on the
same database ?  Mostly the result set will contain only 1 raw. Is there
is any way to improve the selection speed?



How on earth can anyone answer this question except for you. Just
perform your query 2000 times and time it. Make sure you have indexed
fields you are searching on.

--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation https://edu.osgeo.org/
---
collaborate, communicate, compete


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Selection Time

2006-11-28 Thread Lloyd 
Hi,
  How much time can it take to perform 2000 selection queries on the
same database ?  Mostly the result set will contain only 1 raw. Is there
is any way to improve the selection speed?

Thanks,
  Lloyd


__
Scanned and protected by Email scanner

-
To unsubscribe, send email to [EMAIL PROTECTED]
-