TABLE "informix".cs_cust row size = 758 number of columns = 50 index size = 331If customer says table growth rate 100000 rows per month.We have 2 GB chunk size and if dbspace has 4 chunks then How to forecsast for filling the dbspace?Like with 100000 rows per months in what time dbspace can be filled ?ThanksAmit
Also depends on how many variable length columns you have and the size of each column for each row.Rather than trying to work out a complex formula just create a test table and insert 100,000 sample rows...Regards,
Why not just create the table, load it with 100K rows of real data and run oncheck ?
I like David's, Paul's AND Art's answers ... however, data growth is rarely "linear" ... be aware as sizing for linear growth as opposed to compound will catch you out fairly quickly.
Linear starting at 1,000,000 then 12 months growth at 100,000 per month => 2,200,000
Compound starting at 1,000,000 10% growth per month for 12 months => 3,138,428
"That Friday feeling"