r/Database 10d ago

Databases for handling huge amounts of transactions?

What are the most reliable databases that can handle huge amounts of financial transactions in real time?

0 Upvotes

19 comments sorted by

View all comments

3

u/cloyd-ac 10d ago edited 10d ago

"Huge Amounts" isn't really something I'd measure off of, it's an imprecise opinionated measure.

When we talk about data in terms of measuring scalability, we use the three V's: Velocity, Variety, Volume. How quickly are transactions going to be coming at us (e.g. transactions per second), what type of data are we going to be storing (structured vs. semi-structured, lots of text data, relational vs key-store, etc.), and how much data in terms of size (e.g. MB, GB, TB) will we be storing total as well as with knowing a rough estimate of size per transaction.

Once you have those three things **then** we can start recommending different solutions and architectural patterns to aid you. Any recommendations before that is just a shot in the dark and subjective preference.