News for hackers. Stuff that matters.
Re:Why SELECT * is bad for SQL performance (2020) by jimsmart on Monday February 15, 2021 @11:45AM (#26144349)
In an ideal situation, agreed. But surely that depends entirely on how many tables are being queried (how many tables already exist in the cache), the size of the rows, how much RAM the host has / how big the cache is, plus a few other variables most probably.

What I mean is: like all other things, it depends. And with assumptions like this, it is generally better to measure.

There are no comments on this comment yet.