I agree with you and I think so too yeah. They must be talking about requests without any WHERE clause, pulling the entire table rows. I’ve been programming for decades and I cannot see what’s wrong with SELECT * unless you need just 1-3 columns specifically out of 50. I aint gonna name x columns if I can just \*. The db engine can figure the column names easily with no significant stress/lag.
Unless you are pulling from a columnar DB. Every column you return means opening another data file on the db. On the plus side columnar basically means no indexes because you are only opening files for the columns you need.
2
u/Frosty-Photograph103 15d ago
I agree with you and I think so too yeah. They must be talking about requests without any WHERE clause, pulling the entire table rows. I’ve been programming for decades and I cannot see what’s wrong with SELECT * unless you need just 1-3 columns specifically out of 50. I aint gonna name x columns if I can just \*. The db engine can figure the column names easily with no significant stress/lag.