As time goes on, the size of the Database continues to grow with every Transaction that is made. The busier your business - the more sales that you do - the quicker your DB will grow.
Since running for just over a year, my DB contains approximately 85000 transactions (which nearly doubles in the
[AccountTransactionValues] table to over 170000 rows) and the size of the DB is about 250 MB.
While there is a simple method to delete all Transactions and set your DB to “new”, this method will also wipe out all Account Balances - which might not be desirable in a lot of cases.
I want to start the discussion regarding a method by which we can remove all Transactions, yet leave Account Balances intact. Simply, I want to reduce the size of the Database without affecting Workperiods (Z-numbers), Ticket Numbers, and Order Numbers.
Open to all comments, suggestions, insights. Let us hear what you have to say in regard to DB size and performance.