C
ChUIMonster
Guest
If the OS sees the network as being twice as slow then I don't think you can blame Progress for that. Other databases might be less sensitive to network speed if they are less "chatty" than the Progress client/server protocol. If you cannot get the OS level difference resolved and have to accommodate slower speeds then you might want to try increasing -Mm and using the various -prefetch* parameters rolled out with OE10.2B06. -prefetchNumRecs is the most influential. Using FIELDS lists along with a very large -prefetchNumRecs is quite helpful. You're getting killed in the "no prefecth" and "share-lock" examples because those are not "no-lock queries" and each record is fetched individually which takes (at least) 3 network messages. So the impact of slower speeds is magnified.
Continue reading...
Continue reading...