On Mon, 17 Dec 2007 17:34:26 +0530, "Sreedhar.a" <[EMAIL PROTECTED]> wrote:
>Hi, > >I am working with the database of 40k records. >My database table contains the metadata information of audio files. > >When I searched for the first 50 records, the heap usage is small. >when I searched for the last 50 records, the heap usage is almost equal to >searching the entire database table. > >Is it the same way the sqlite behaves? or I am doing anything wrong. Apparently the page cache is growing in memory. It all depends on the schema and the select statement how SQLite behaves. Apart from the architecture and optimization pages on the SQLite website, you may want to study http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor >Thanks & Best Regards, >A.Sreedhar. -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
