Subject | storage space issue and field length |
---|---|
Author | Francesco Lamonica |
Post date | 2005-09-13T11:06:12Z |
Hi, i am planning a database to hold network traffic measurement data
(notably bandwidth and number of packets)
since i will have to store at least three months worth of data the sheer
extimate in terms of bytes is around 2TB.
I am wondering if limiting the precision of numerical data fields will help
keep the db size at reasonable levels. e.g. using 16bit fileds vs 32bit
ones.
thanks
[Non-text portions of this message have been removed]
(notably bandwidth and number of packets)
since i will have to store at least three months worth of data the sheer
extimate in terms of bytes is around 2TB.
I am wondering if limiting the precision of numerical data fields will help
keep the db size at reasonable levels. e.g. using 16bit fileds vs 32bit
ones.
thanks
[Non-text portions of this message have been removed]