News for hackers. Stuff that matters.
Re:Understanding N + 1 queries problem by jerf on Monday January 02, 2023 @02:52PM (#34222775)
There is still also non-zero overhead associated with making queries in general, in both the querying and query-answering process.

The ceiling of the range where you can get away with this without user-visible performance impact will be much higher, and the relative performance difference may be smaller, but in general fewer queries for the same data will still be better in general.

Even with an in-process DB, you're still essentially making a sort of context switch.

Re:Understanding N + 1 queries problem by eatonphil on Monday January 02, 2023 @02:56PM (#34222811)
Piling on about overhead (and SQLite), many high-level languages take some hit for using an FFI. So you're still incentivized to avoid tons of SQLite calls.

https://github.com/dyu/ffi-overhead