> Transactional queries are usually limited to something like "get a single record, preferably from cache".
simply wrong
simply wrong
"Get a row" "Get ten rows"
Etc, etc. All constant, all predictable, all not requiring unpredictable time to run. Also caches nicely.
What is "simply wrong" here?