I think his issue is that the database is changing size too often. He wants it to automatically expand in larger chunks so there is less fragmentation on the disk.
Good idea, assuming it's settable via pragma. On 9/13/05, Jay Sprenkle <[EMAIL PROTECTED]> wrote: > On 9/13/05, GreatNews <[EMAIL PROTECTED]> wrote: > > > > Hi D. Richard Hipp, > > > > I'm developing a desktop rss reader using your excellent sqlite engine. > > One > > issue my users found is that sqlite database can get heavily fragmented > > over > > time. I'm wondering if it's a viable suggestion that sqlite pre-allocates > > disk space when creating database, and grows the db file by bigger > > chunk(e.g. grow by 20% or so in size each time)? > > > > Why not do a vacuum every 10th time (or something similar) you exit the > program? > > --- > The Castles of Dereth Calendar: a tour of the art and architecture of > Asheron's Call > http://www.lulu.com/content/77264 > > -- Cory Nelson http://www.int64.org
