Currently we have an application built on oracle forms with sql*plus.
We are trying to use it over a vpn from a branch office and it is very slow, taking 5 minutes to just load up. File transfers between both offices are able to go at around 500KB/ps with a latency of around 200ms.
When we try the oracle forms program it is exceptionally slow. taking atleast 10 minutes to do anything. the average transfer rate when the program is open is also around 5KB/ps.
How can i improve the performance of this from the branch office? Would it be better to put another database here and synch them?
So far i have tried chaning the SDU to 32K and the TDU.
I posted a similar question here: http://www.experts-exchange.com/Database/Oracle/10.x/Q_24383387.html
where it was suggested we change to an odbc driver but unfortunately this isnt an option.
Thanks for youyr help.