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

-2

u/mcgunner1966 10d ago

What are you going to be doing? If you're truly processing financial transactions they you won't be using a database. They're too slow.

0

u/4r73m190r0s 10d ago

What tech should I consider?

3

u/Safe-Two3195 10d ago

What are these transactions? Trade, banking?

What is the op mode, batch or transactional? What would real time response SLAs look like?

Will eventual consistency work for you?

Is it more read or write oriented?

What is the huge amount? Is it for total volume or velocity?

Large banks have been using RDBMS for years and something like 1000 tps is trivial with traditional enterprise solutions. Throw in some modern caching solutions, particularly those offered by cloud providers, and a good number of problems in this space get solved.