J
jmls
Guest
9566 = as near as dammit to 4793 * 2 which means 1 customer, 1 address however, 13501 logical / 4793 record = approx 2.81 logical per record 33277 logical / 9566 record = approx 3.47 logical per record which indicates (to this gui guy, anyway!) that both the customer (2.8 reads per customer) and the address record is fragmented. At a guess, do you create the address record. save it (probably with only a key) and then update it (so the record no longer fits in a single block ) ? your live db may be worse because there is a lot more data writing going on, and therefore fragmenting the records even more - and sending them all over the disk rather than in a contiguous block trying dumping and loading your dev db and see what happens in terms of performance Julian On 8 May 2014 16:24, James Palmer wrote: RE: Difference between logical reads and record reads Reply by James Palmer I should add - Progress 11.2.1 on Windows 2003 Server (32 bit still!!!!). Stop receiving emails on this subject. Flag this post as spam/abuse. -- Julian Lyndon-Smith IT Director, dot.r http://www.dotr.com "The bitterness of poor quality remains long after the sweetness of low price is forgotten” Follow dot.r on http://twitter.com/DotRlimited
Continue reading...
Continue reading...