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

  • Thread starter Thread starter Andy Whitcombe
  • Start date Start date
Status
Not open for further replies.
A

Andy Whitcombe

Guest
I did a whole host of testing, and for the application being designed, the better solution appeared to be the :FORWARD-ONLY attribute on the query. It was consistently quicker that the :CACHE option and resolved the reads. Thanks to frank.meulblok ; appreciate the input, we have used that in the past, but not consistently... perhaps going forwards it could be one for the development team to review.

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