Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec

Chan wrote:

> How much history you are going to keep for how long and how many
> concurent users going to access data.
>
> here is math:
> 1 see 30mb
> 1 min 1.8gb
> 1 hour 108 gb
> 1 day 2.592 TB

Folks, the OP said:
30Mbits/sec

That's "bits", not "Bytes"!

In bytes, that's around 3.333 MB/s.

Which is fine with most current hardware. 40000 records/sec means nothing: what we need to know is how many bytes/rec on average, and how many rows can be batched into a single write operation. Received on Wed Feb 08 2006 - 05:57:39 CST