I think I need to catch up on my reading.
I've tested both SQL methods for compacting the database. Both work,
although the CHECKPOINT DEFRAG seems to be the better approach as the
file doesn't have to be closed and reopened.
Preliminary impressions seems to indicate a performance improvement
after compaction. This may be a factor in other threads relating to
performance issues.
I'll try to do more controlled testing to see if this is true.
Thank you for doing the research and sharing these methods. This (and
your other contributions) and your recent thread with Barbara has been a
great help.
Marc
andrew wrote:
The other day the question came up about recovering space from deleted
records in a Base ( embedded ) database.
I mentioned using the command
SHUTDOWN COMPACT
in the SQL window, and that you would need to close and reopen the
Base file.
You can also use this command
CHECKPOINT DEFRAG
without the need to close and reopen the Base file then.
So you can do so either in the SQL window or in a script with
oStatement.ExecuteUpdate( "CHECKPOINT DEFRAG" )
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
