On Jan 4, 2008 4:04 AM, Sreedhar.a <[EMAIL PROTECTED]> wrote: > Hi, > > I am working in 3.3.6 C code. > > I created a database and i started inserting 100 records . > After inserting i checked the database File.Say 98% of the database is > filled and the remaining 2% is left out without use. > Then i inserted next 100 records and i found again 2% is left out.So totally > 4% is left free. > I think by using "PRAGMA auto_vacuum = 1;" i can do fragmentation. > > I need the database to shrink when ever it finds freespace in the database > file. > Can any one please help. > > > Best Regards, > A.Sreedhar. > >
The way b-trees (the internal file structure sqlite uses) work, it is very hard to use up 100% of the space. Vacuuming will only free empty pages and won't solve this. -- Cory Nelson http://www.int64.org ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
