Forum Post: RE: Difference between logical reads and record reads

  • Thread starter Thread starter James Palmer
  • Start date Start date
Status
Not open for further replies.
J

James Palmer

Guest
I did the D&L as it's good practise (not done one before). Out of interest "If you do a for each on customer we get 4793 record reads but 13501 logical reads. It takes x amount of time. If you do a for each on customer, first address of customer, we get 9566 record reads but 33277 logical reads. It takes 2.5x amount of time compared to just customers. In live it can take up to 10x as long - probably due to the reduced buffer hits." Since the D&L it's now 9605 logicals for the first query, 28721 for the second. So there's definitely a reduction but not massive. Tom's scepticism is upheld ;)

Continue reading...
 
Status
Not open for further replies.
Back
Top