About database version Compression

About database version Compression

The geographical database has been edited for a period of time, and the number of records in the database status and Delta table of each element class has greatly increased. How can users improve performance by running the compress command?

Solution: The compress command deletes all database statuses that are no longer referenced by version and moves all records in the Delta table to the base table. To achieve maximum compression efficiency, You can first reconcile with the default version, submit the version, and delete each version. To improve performance, at least use the default version to reconcile and save each version, and then perform compression. This ensures that all edits in the default version are compressed from the Delta table to the business table. Remember that the compress command can also be executed without first performing version reconciliation, submission, and deletion, but the compression efficiency may not be obvious.