clueless! Please help

[nigela]

We have developed our webspeed application on our LAN.
The config of our deployment is that our webserver is connected to our firewall, and our transaction server is on our LAN behind our firewall.

We have a VPN to a site with a UNIX machine hosting an 8.3b database. When we run a .r there is a delay of 30 seconds, but this was instant when we developed on our LAN.

The bandwidth of the connection at the webserver end of the VPN is 2MB, and at the UNIX machine end is 1MB.

We can access the unix based databse instantly, but when we run the webspeed .r it takes 30 seconds. Does anyone have any ideas as to why the performance is so different?

 

[RichardThorp]

When you say it connects instantly, is that you connecting to the Progress remote database directly via shared memory, or are you connecting client-server from your PC.

One thing to check: take a copy of the pf file which your webspeed agent is using at startup - and then put it into tramlines on the webspeed server/remote pc and execute a connect -pf using it - try and narrow down whether it is the connect statement taking too long, or the executing of the r-code.

Has the database you are connecting to got a lot of fields? If so, you may want to think about a schema cache to reduce connect time (if this is the problem)

Richard