I have an issue with server growth- as my clients use their software subscriptions, they will accumulate more and more closed files. For example, if they are adding 100 records a month, and the life of each record is 12 months, then there will always be a standing active record count of 1200, plus the records that have been closed.
So- i have two noob database questions:
1. will those closed records slow down my database as they pile up, even if they are not accessed?
2. If so, can I setup a separate database server that just handled them- so they do not bog down my main active database?
Thank you.
So- i have two noob database questions:
1. will those closed records slow down my database as they pile up, even if they are not accessed?
2. If so, can I setup a separate database server that just handled them- so they do not bog down my main active database?
Thank you.