Re:Many small queries are efficient in SQLite
by ubercore on Tuesday February 16, 2021 @01:45PM
(#26157268)
Nested resolvers can incur extra queries as you follow down the tree, unless you put extra effort into pre-fetching what child nodes need, or some kind of data loader as GP suggested.
A straightforward, naive implementation would resolve `parent`, then a resolver for `child` would execute, then for `field`. If `child` is a table linked by an FK, a second query would be executed, unless you pre-fetch the results through a join when resolving `parent`.
[ Parent
| on HN ]
There are no comments on this comment yet.