This is eluding me. I have four different databases with the following row/record counts (specified in the titles) with corresponding total database sizes. I need to determine what the database sizes will be when there are 50 million records.
Database/Size Empty, 5k records, 10k records, 50 million records
A 7626 kB 20 MB 31 MB ?
B 6298 kB 6298 kB 6298 kB ?
C 7801 kB 7914 kB 7914 kB ?
D 12 MB 1209 MB 2405 MB ?
The sizes for databases B and C are obvious.
I don't think I can simply take the values found for 10k - 5k and use that as a delta and then multiply by the difference between 50 million and 10k (using 50 million would be close enough if I am on the correct path). Figuring this out will help our database administrator pre-size our databases.
I apologize that I have no idea what tag to use for this. =/
I think you are intended to say for A that the increase is roughly 23MB/10k records, or 2.3 kb/record. This leads to about 115 GB at 50 million records. For D, the increase is about 24MB/10k records,so the size is close to the same. These, and your answers for B and C, assume that the size can be approximately represented by a model of some size to create the database and approximate linear increase per record. This may or may not be correct.