[progress Communities] [progress Openedge Abl] Forum Post: Vst _areastatus Very Slow Access

  • Thread starter Thread starter patrick.elsen
  • Start date Start date
Status
Not open for further replies.
P

patrick.elsen

Guest
Hi, Running the code below takes between 700ms and 800ms on a database with 69 areas (64 ai areas included) and this long response time is caused by the find _areastatus. ETIME(yes). FOR EACH _Area NO-LOCK: FIND _Areastatus WHERE _Areastatus-Areanum = _Area._Area-number no-lock. END. DISPLAY ETIME(no). A for each of the entire _areastatus vst takes max 15ms. Is it possible to rewrite this sample code in a way that performs better? Kind regards, Patrick

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