PBDR.COM

About   -   Contact   -   Purchase   -   Search   -   What's New

 
 
Distributed Data Transfer Speeds
Whilst designing the distributed business entity for my new framework I ran some time trials on the fastest way to transfer data across the network using the Distributed PowerBuilder Winsock driver. The results were very interesting!

I used a datastore on the server PC with 12 rows of data totaling about 4k of data. The rows contained strings, numbers, dates and times. I transferred the data 100 times resetting the target datawindow each time.

Method

Time in Milliseconds

Using an unbound array of Structures passed by reference which matched the result set, set/get with the dot notation 35265
Using an unbound array of Non Visual Objects passed by reference which matched the result set, set/get with the dot notation 32703
Using a String by Reference, describe and importstring 2437
Returning data as a string, describe and importstring 2000

I really found the difference in the timings amazing considering it was transferring exactly the same amount of data each time. The difference between the string by reference and value is easily explained because even though the string was empty on the way to the server empty still had to be passed.

 

Top of Page

Legal Notice

Ken Howe 2011