On 6/13/06, RohitPatel9999 <[EMAIL PROTECTED]> wrote:
After using such application, all used SQLite DB files gets fragmented.How to avoid such fragmentation ?
You want to use the scheduled task function of windows to run a disk defragmenter. I find that once every two weeks is sufficient for a busy system. Once per month is probably fine. This is an operating system issue, not sqlite. Sqlite does not control where it's data is placed on the disk