| 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 |
Back 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. |