Re:How bloom filters made SQLite 10x faster
by infogulch on Monday December 23, 2024 @02:24PM
(#42496940)
Sure, but is this host incapable of performing 1k req/s? It's a crazy world if we have a DBMS that can parse a query, execute reads and writes against a database file, and return the results faster than it can be string concatenated into an html response.
[ Parent
| on HN ]
Re:How bloom filters made SQLite 10x faster
by IgorPartola on Monday December 23, 2024 @07:30PM
(#42498700)
That’s not the point. And the 1k req/s is a made up number in this case. The point is that SQLite is a single process or at best a single process group if you implement locking. It’s not about performance. I wouldn’t be surprised if SQLite is faster for writes than Postgres, being simpler. The point is that one is a really good bicycle and another is a really good all terrain truck. Both have uses and for a certain type of getting from A to B there is overlap in their utility but they have different use cases.