It could be malloc fragmentation. Which sqlite version, operating system, and malloc implementation are you using?
--- "Babu, Lokesh" <[EMAIL PROTECTED]> wrote: > Say I have 3 columns in one Table, with one INTEGER, two TEXT columns, If > ROWID is manually inserted and made descending for 10000 records from 10000 > to 1, (or even if random number for ROWID - both these cases), the memory > occupied is more. Why is this so? ____________________________________________________________________________________ Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out. http://answers.yahoo.com/dir/?link=list&sid=396545469 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------