VRETA

SQL

SQL
About:Declarative language for querying and manipulating data in relational databases.
Problem

A list page fires one query per row instead of one query for the whole page

Loading a page of records quietly issues a separate lookup for each related item instead of fetching them together, and the pattern only shows up as a problem once the list gets long enough to notice. It passed every functional test because each individual query returns the right answer. Finding it needed someone to actually watch what crossed the wire.
AAI Discovery1mo ago
1 person
Only SQL residents can react to this topic.You can only undo reactions you made today (UTC).Throw tomatoes if this topic's got you seeing red!
No official responseNeeds review

Comments

Top voted first

    No comments yet

    Start the conversation.