4 ms·
> Push less data through wires. In the systems I work on this has been a big one. In SQL people are pretty good about not writing `select *` in production code
by spicybbq 2y ago
> Push less data through wires.
In the systems I work on this has been a big one. In SQL people are pretty good about not writing `select *` in production code, but when querying directory servers, redis, mongodb, etc. people get sloppy. When a system is small, it's enticing to pull in lots of data and work with it in code instead of writing real queries. This doesn't scale.
- bunderbunder 2y agoUnless you use an ORM, in which case I'm used to seeing it be all SELECT * all the time. And then you get an entire generation of engineers who've never known any other way to talk to a database going around complaining about how this Miata is so slow when really it's just that nobody ever taught them how to shift out of first gear.