Re: Forms application performance over WAN

I have been using forms 4.0 and 4.5 over a wide area network, that runs at 64k bits/sec. The performance is poor and in my opinion (not tested) there seems to be no performance difference between 4.0 and 4.5 and a slight but not great performance improvement in going from sqlnet 1.x to 2.1, but as this also meant a change from decnet to TCP/IP this may have had something to do with this.

In discussion with Oracle the way to improve this is to move as much of your code on to the server as possible! i.e. use database triggers as much as possible and try and make most of your PL/SQL code stored procedures. You then can make 64kbit links act with the alacrity of a snail on methylamphetamine, as compared to a dead snail swimming in treacle.

The best solution (as advised by Oracle) is of course to install a local database and replicate.

Doug Taylor Received on Sun Dec 31 1995 - 00:00:00 CET