4 ms·
I run a complex CRM that handles 1.2 million USD in transactions every year. It is running sqlite with a simple in-memory cache (just a dict) that gets purged w
by michaelmcmillan 9y ago
I run a complex CRM that handles 1.2 million USD in transactions every year. It is running sqlite with a simple in-memory cache (just a dict) that gets purged when a mutating query (INSERT, UPDATE or DELETE) is executed. It is simple and fast enough.
- simplify 9y agoTell us more! How many transactions per second do you process? Do you use multiple databases?
- pvg 9y agoIf you assume each of these transactions is a dollar, you get a bit under 0.04 transactions/sec on average. If peak load is 25x average, that would come out to 1/sec.
- neuland 9y agoLike the other commenter mentioned, I'd love to hear more about this too. How are you doing backups and deployment?
- nerfhammer 9y agois this single threaded? single client?