Kees Nuyt wrote:
> On Sun, 20 Sep 2009 12:02:17 +0800, Mohit Sindhwani
> <m...@onghu.com> wrote:
>
>   
>> Hi!  An embedded SQL-based database that we used earlier had a concept 
>> of packed fetches - this would mean that we could create a certain 
>> buffer for results, prepare a query, execute it and read back the 
>> results in "groups" of 10 or 20 or 1000 (or "n") results per call.. this 
>> was significantly faster than reading the results one at a time.
>>
>> Is there a parallel?  Or is it possible to implement such a thing?
>>     
>
> Have a look at:
> http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
>
> It is not exactly what you are looking for, but it may apply
> to your use case.
>   

It is not exactly what I am looking for - but the link is very 
interesting, thanks.

I'm just trying to see if there's a way to move more data per request.  
But it seems not (for now).

Cheers,
Mohit.
9/21/2009 | 3:06 AM.

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to