wow! thanks. On 11/14/07, Kees Nuyt <[EMAIL PROTECTED]> wrote: > > > On Tue, 13 Nov 2007 20:46:06 -0500, "Benilton Carvalho" > <[EMAIL PROTECTED]> wrote: > > >I'm in the process of creating the whole db now and will give it a > >try... maybe creation is the worse part, as I'm going to be accessing > >contiguous sets of rows (all columns) at a time... something like: > > > >SELECT * FROM table LIMIT 10000 OFFSET 20000; > > Please read this article from drh to improve performance on that > one. > > http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor > -- > ( Kees Nuyt > ) > c[_] > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > >
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
