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] -----------------------------------------------------------------------------
