Subject | Interbase / WAN |
---|---|
Author | yartax1 |
Post date | 2004-11-16T16:50:48Z |
Hi to all,
I will explain a WAN acces test with ADSL/2Mbit on server and client.
In my app I got a form with 6 TIBOQuery. It took about +-50 s to bring
data to form. The max record count in one query is 300 (integer and
varchar(50)), other queries is only about 10/20 records. All queries
is a simple "Select a.x, a.y from xxxx..." form and the server side is
not bussy.
To increase performance I did next:
All these datasets set to read only, and gained 10 seconds.
Any other tip to increase performance?
Is anyway a method to "compress" TCP data?
Thanks.
I will explain a WAN acces test with ADSL/2Mbit on server and client.
In my app I got a form with 6 TIBOQuery. It took about +-50 s to bring
data to form. The max record count in one query is 300 (integer and
varchar(50)), other queries is only about 10/20 records. All queries
is a simple "Select a.x, a.y from xxxx..." form and the server side is
not bussy.
To increase performance I did next:
All these datasets set to read only, and gained 10 seconds.
Any other tip to increase performance?
Is anyway a method to "compress" TCP data?
Thanks.