It’s tempting to think about software performance in “vacuum”, disconnected from any inputs and outputs, abstracted down to optimizing latency or throughput. This way the problem becomes much simpler to deal with, it’s easier to convince others of its importance – after all everyone wants to do more with less. It’s…
Visit erthalion.info → RSS feedOn Hacker News Dec 2017 – Jul 2021
Yes, I know, it’s a long text, and it was my conscious decision to write it in this way. But fear not! Imagine that you read a book, take a look at the introduction and first few interesting sections, think about it and then find time to read further. I hope I’ve left enough references, so if you don’t get some ideas…
As such, there’s really no “standard” benchmark that will inform you about the best technology to use for your application. Only your requirements, your data, and your infrastructure can tell you what you need to know.
The select part is actually fine. But for updates, especially for complex updates, it could be pretty verbose and far from being ergonomic. What would you say to this syntax instead?
I have to admit, my research blog posts are getting longer and longer. From one side I find it genuinely encouraging, because if one gets so much information just by scratching the topic, imagine what’s hidden beneath the surface! One university professor once said “what could be interesting in databases?”, and it…