Slow Query on remote computer

[Philae_infor]

Our Client-Server application has been installed in a remote computer thru a digital line and a 64 Kbit modem but we are having problems with the query speed of our OracleDataSets (in some cases we have a delay of about 2/3 minutes to open a form in a remote workstation).
We are using DOA 3.3 Professional and we already have tried to increase/reduce the ReadBuffer property in each Dataset.
We also use Borland

 

[Marco Kalter]

To reduce network traffic to a minimum for a TOracleDataSet, you can do the following:

• Set the ReadBuffer property to a higher value. This will primarily reduce the number of roundtrips, but will also reduce the total number of bytes that are sent and received for a query.
  
• Set the QueryAllRecords property to False. By default it is True, and all records in the result set will be fetched from the server when the dataset is opened. When it is False, records are fetched when the application or a data-aware control needs them.
  
• Don't use any of the Dictionary properties. This requires extra queries, though the TOracleSession will buffer this information for the duration of the connection.
  
• Use more restrictive queries. Make sure that the end-user only sees those records that are relevant.

The optimizer goal does not affect network traffic, but affects the way the query is executed.

------------------
Marco Kalter
Allround Automations