Re: Inserting 5000 samples per sec in real time

[Rick James]

Or batched inserts. I know of a C program that gets ~100K rows per day. It batches them 7000 at a time (a bit excessive); it hums.

A potential problem -- If your table + index is bigger than can fit in cache, and if you have "random" index keys, you could be limited by disk speed.

In data warehousing applications like yours might be, I recommend nothing more than an auto_increment key on the 'fact' table. This avoids the random-index problem I mentioned, but requires you do other things for reporting.