Has anyone done anything to flush out the chglog table before? I am working
on a DB and about 50% of the database size is contained in the ChgLog table.
During a dump and load, the dump file for this table is 4.1GB while the next
largest table(tranglc) is only 601MB and the entire set of dump files is 8GB
total. The dumping of that table alone took over 2 hours, while the whole
process took about 3 hours.
This seems excessive from my point of view and if there is a "safe" or
efficient way to flush this, it would certainly speed up the time it takes
to do a dump and load on this database.
Thanks
Ned
on a DB and about 50% of the database size is contained in the ChgLog table.
During a dump and load, the dump file for this table is 4.1GB while the next
largest table(tranglc) is only 601MB and the entire set of dump files is 8GB
total. The dumping of that table alone took over 2 hours, while the whole
process took about 3 hours.
This seems excessive from my point of view and if there is a "safe" or
efficient way to flush this, it would certainly speed up the time it takes
to do a dump and load on this database.
Thanks
Ned