Joined 6y, 17w ago. Seen 5y, 26w ago.
👽 Lucian Marin SQL is the main bottleneck on Sublevel. Instead of planning new features, I'm tweaking the Postgres query planner. It's very hard to maintain a certain level of performance with SQL. Let's say you want all requests to be loaded in exact same amount of time. You can't do that. Each SQL query is different and they might behave differently under heavy load. I doubt NoSQL is any different. That's why a key-value store like Redis is perfect for high performance applications. You know in advance what's the performance for each value stored, so you can plan features as you write code.
Jonah George Out of curiosity, what sort of queries are the primary bottleneck?
5y, 31w 1 reply