On 6/13/06, Teg <[EMAIL PROTECTED]> wrote: <snip>
I'd think allocating the space for the file, then copying the SQLite DB to this new file, renaming the old and renaming the new would defragment the file too.As an experiment, I copied a 5G db from one filename to another and it changed from 6700 fragments to 1.
Forgive my ignorance, but how are you folks determining that the files are fragmented? -- Jeff Macdonald Ayer, MA
