Imagine for example that you have per record caches. You can run a query to get ...

keithnoizu on Oct 21, 2020 | parent | context | favorite | on: What ORMs Have Taught Me: Just Learn SQL (2014)

Imagine for example that you have per record caches. You can run a query to get ids with out joining to the table and then simply fill in any gaps in your cache with a follow up query.