I found doing a dump and load, and reindex prior to running the Database Purge and Summarize improved performance of the purge on everything except PartTran and Labour, they are still very slow to purge. I'm stumped on how to purge those larger tables, seems we're adding new records faster than I can purge the old ones.
GL journal Detail, part tran, job material, labor detail, book detail, and pcinvalue are all things that can be purged and summarized right?
I am working on a dump and load project(50GB DB) and some of these tables are just unimaginably large and I would like to help them trim this down for time sake.
The GLJRNLDTL table is 14GB alone, parttran is 7GB, jobmtl is 5GB, while the TranGLC is 8GB, I know that isn't one that can be trimmed down(I don't think anyway). I don't even know what the pcinvalue is, and it is 5GB as well.
All other tables are at leastunder a GB, even change logwhich usually is one of the largest.
The GL Journal Data table takes almost 12 hours just by itself.
I am looking into some faster drives to run the dump and load on, but just physical data is an issue as well.
Any suggestions welcome.