3 ms·
Oh, there are dozens of databases that will do 150k transactions per second. The issue with database throughput for most applications is the storage layer, whic
by AaronFriel 13y ago
Oh, there are dozens of databases that will do 150k transactions per second. The issue with database throughput for most applications is the storage layer, which is more difficult to fine tune when working with a cloud service.
With Azure, you have to use one of their very large instances and connect and stripe virtual disks yourself to hit 40k IOs per second, and I think that's just barely possible. With Amazon, you are limited to about 48k IOPS and again, you have to use EBS and provisioned IOPS disks and stripe. Not sure about Google's services.
- MichaelGG 13y agoOr take the VoltDB way and persist to memory (in the commercial version AFAIK).
- AaronFriel 13y agoI would heartily disagree with their definition of persistence.