[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Multi Table Dynamic Query Issues Using -rereadnolock

  • Thread starter Thread starter 2087
  • Start date Start date
Status
Not open for further replies.
2

2087

Guest
Ah yes - that was the point of your post wasn't it! I focussed on the idea FORWARD-ONLY improving performance and forgot about the rereadnolock :-) I have rerun the tests using -rereadnolock. I can confirm that -rereadnolock slows it down and using FORWARD-ONLY gets it back to the speed (or very nearly) that you would have without -rereadnolock. FORWARD-ONLY appears to make no difference unless -rereadnolock is being used. DO vs REPEAT - I see no difference in speed.

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