 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| Ÿ |
Must have
solution to minimize queries
|
|
|
| Ÿ |
Need flexibility
to reduce to 1 query, 1+1
|
|
|
|
query or N+1
query where appropriate
|
|
|
|
– |
1 Query when
displaying list of customers and
|
|
|
addresses – known
as a “Join Read”
|
|
|
|
– |
1+1 Query when
displaying list of customers and
|
|
user may click
button to see addresses – known
|
|
|
as a “Batch Read”
|
|
|
|
– |
N+1 Query when
displaying list of customers but
|
|
|
only want to see
address for selected customer
|
|