Community
Showing results for 
Search instead for 
Do you mean 
Reply

Volume limits

Tuned Listener
Posts: 40
Country: USA

Volume limits

How many records can a database hold and run with relatively good speed?

Bronze Contributor
Posts: 1,394
Country: USA

Re: Volume limits

While I'm not an engineer, I have seen this question asked and answered before. 

 

It depends.  (What did you expect)

 

You are limited to the size of your hard drive.  In a single user environment, that should show no degradation with today's computers, HDD, and HDD Cache.

 

On the other hand, in a multi user environment the number of users will ultimately affect performance.  I would expect that some of the engineering gurus that frequent this board may jump in with some limiting numbers. 

 

BTW, my storage specialist once told me that when the HDD reaches 45% full it should be considered full and performance is guaranteed to drop off at that point. 

John Purdy
ACT! Premium 2016 (V. 18)
Dell XPS Ultrabook with 4GB, Win 10 Pro, & Office 365, 32bit