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
andrew wrote:
Marc Blakely wrote:
Drew, I've recently run into a similar situation with a database I'm
developing for work.
There are two tables which I import records into from a csv file via
Calc. I delete the previous records from each table prior to the
import (actua
of the tables, definition only, and deleting the
old tables thinking this would purge the old data. It's still there.
I haven't had a chance to look, but it seems there should be some method
to 'compact' the database tables.
Marc Blakely