On Wed, 14 Jun 2006 03:34:04 -0700 (PDT), RohitPatel9999 wrote:
>But like some other Databases, if SQLite does provide any way to set >auto-increment for database file by some fixed percentage (say 20%, 40% >etc.) such that everytime database file reaches some threashould size it >automatically add free space, that will reduce file defragmentation. >What are your thoughts on that ? One of Sqlite's strengths is its simplicity. Creeping featuritis plagues all software development and what you are suggesting fits nicely with that definition. The zero configuration principle is violated so that a very small percentage of applications can do something as part of the database module instead of leaving it to the operating system, running a cron task at 3.00 am. Regards, Chris