[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: FOR EACH NO-LOCK performance using client-server connection (impacted by available inde

  • Thread starter Thread starter George Potemkin
  • Start date Start date
Status
Not open for further replies.
G

George Potemkin

Guest
> I was under the impression that CAN-DO() and user defined functions were the only things that currently cause that to happen. It's still true. I tested: FOR EACH Customer NO-LOCK WHERE Customer.Country EQ "USA" vs FOR EACH Customer NO-LOCK WHERE STRING(Customer.Country) EQ "USA" vs FOR EACH Customer NO-LOCK WHERE Customer.Country EQ "USA" USE-INDEX Cust-Num vs FOR EACH Customer NO-LOCK WHERE Customer.Country EQ "USA" NO-PREFETCH Results: Messages received 8 8 8 35 Messages sent 7 7 7 34 Bytes received 720 748 740 2772 Bytes sent 5387 5387 5387 7141 Records received 0 0 0 0 Records sent 33 33 33 33 Queries received 7 7 7 34 Time slices 32 32 32 0 Tested with 10.2B. Note that at least in 11.7 statistics is broken: first five rows are zeroed. Result is the same in _ActServer and promon/R&D/2/2 Activity: Servers.

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