[progress Communities] [progress Openedge Abl] Forum Post: Slow Queries With Parameter...

  • Thread starter Thread starter e.schutten
  • Start date Start date
Status
Not open for further replies.
E

e.schutten

Guest
I have done some query testing. The physical and Dynamical quiries are retrieving 100.000 records for two tables like for each table1, each table 2 where. In the table below you find the avarage time in ms. Can somebody explain why the queries are dramatically slow when using rereadnolock and why they are slow when not using rereadnolock and not using the CACHE option? Dynamic Physical Reread with no cache 99.000 58.000 Reread with cache 9.000 9.000 No reread with no cache 9.000 55.000 No reread with cache 9.000 9.000

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