We are about to get 10 years of operation with epicor
Our DB i’ts large, almost 300 gb, and 22,092,951 rows in partran. Always rebuild indexes, etc.
some advice or tip to improve performance?
We regularly do a database purge for data older than 7 years to keep the size down
Are you a configurator user by any chance? With a ton of storage space used by the PCValueSet table? If so you might be able to clear a lot of space w/ the “shrink configurator field properties process” (I forget the exact name). Otherwise, the built-in Purge and Summarize tool is the best way to shrink tables like PartTran.
That said, if you’re having performance issues are you sure it’s due to the size of the DB and not something else going on? 22 million rows is big but not absurdly big.
Our client side has never been responsive enough in my opinion, even though our db is at 18GB. Basically since Epicor 10. Misc windows updates keep decreasing performance.
SQL side seems responsive though. I imagine you have ran the PDT testing already.