[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Locking scope

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

2087

Guest
I believe this so - I sure I experienced this many years ago in Progress 7. If the indexes don't allow for the server to read only the records you want it will have to look at the records themselves to establish whether they are wanted in the query results and it locks them whilst doing this. The way to avoid it is change the indexes and/or query so that only the records that you want are read (which could be difficult) - or read them NO-LOCK and then have to read them again (by ROWID or similar) to lock them (which could be slow). Hope that helps. Derek

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