Database performance, meaning how quickly displays are updated and how long it takes to retrieve information, is generally most affected when using XStudio to access a remote database not located on your local area network (LAN).
Performance is directly affected by available bandwidth (data flow capacity) between you and the remote database PC. The lower the bandwidth, the more time it takes to get the data from the remote database server and the longer it takes for the display to be updated.
While there is no substitute for bandwidth, performance problems can be mitigated somewhat when working with a remote database that is not on your local area network.
The host database server normally sends requested information as it resides in the database tables, but can be instructed to "compress" the requested data before sending it to XStudio. Using compression, more data can be sent in the same bandwidth, although at the cost of the time it takes to compress the information on the server end and subsequently decompress the information at the receiver end.
|
Using data compression when communicating with remote database servers located on your local area network may actually reduce performance. If all host application databases you are maintaining are located on your in-house LAN, data compression is not recommended. |
Implementing Data Compression
You can enable data compression in XStudio Preferences by setting the database property Data Compression.
|
You must exit and restart XStudio for changes in the data compression setting to take effect. |
Refer to the table for an explanation of available data compression settings.
Value |
Meaning |
|---|---|
0 |
No Compression. This is the default value and means XStudio will not request compressed data from the database server. |
1 |
Fastest Zip Compression. |
2 |
Fast Zip Compression. |
3 |
Fast Zip Compression. |
4 |
Medium Zip Compression. |
5 |
Medium Zip Compression. |
6 |
Medium Zip Compression. |
7 |
High Zip Compression. |
8 |
High Zip Compression. |
9 |
Highest Zip Compression. |
10 |
RLE Compression. |
You'll notice there are several "flavors" of zip compression, which provide a balance between speed of compression and size of the compressed data. You can experiment with various settings to see which achieves the greatest satisfaction.
