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