C
ChUIMonster
Guest
Network performance of the example you have shown will stink. That is because you are using share-locks. That will result in individual round-trip messages for each record as well as a one-way message to release the lock. If you add NO-LOCK then the records will be grouped into "queries" and bundled into messages. The number of records per message will be influenced by -Mm, -prefetchFactor, and -prefetchNumRecs. Using "FIELDS" can also have a substantial impact. You can measure this stuff with _actServer VST. Kbase 18342 explains network messages.
Continue reading...
Continue reading...