On 9/13/05, Dennis Jenkins <[EMAIL PROTECTED]> wrote: > > > > Even vacuuming won't defrag the file. Disk space is allocated by the OS > and the OS makes no guarantees.
Won't Dr. Hipp's method of making a backup copy also defrag the file? i.e. execute begin exclusive to lock it. copy the file commit rename the files and use the backup copy as the new current database. Assuming your disk free space isn't heavily fragmented. If it is fragmented I believe this will tend to reduce the fragmentation with time, depending on what else is going on at the same time on the machine.
