PowerBuilder and Oracle - Performance Issues
Date: Fri, 30 Oct 1998 17:16:36 GMT
Message-ID: <71cs9k$2si$1_at_nnrp1.dejanews.com>
Hi, we are looking for some help or advice on a problem we are having with Oracle. First some background. We currently have a production system using PowerBuilder 5 against NT Sybase SQL Server 11.5.1. Our users consist of people in the same building as the servers as well as people all over the nation on our WAN.
Now here comes the problem. We decided to move our system to an IBM AIX box which has dual processors and is much more powerful. At the same time we decided to migrate to Oracle 8 since this is our new corporate standard.
To make a long story short we are 99% through migration. Data, procedures, etc. has been migrated. We migrated to PB 6.5 and our application works fine under Oracle 8.0.3. Well actually it works but we are having performance problems with PowerBuilder and Oracle. If we execute a procedure in Sybase, time it, and then execute the same procedure in Oracle the time difference is negligible. But when we execute that same procedure from PowerBuilder there is a considerable amount of overhead. Now when I say considerable you should keep in mind that we are very perfomance sensitive so if a function took 4 seconds before under Sybase and now takes 8 to 12 under Oracle, that is unacceptable.
Now we have traced the PowerBuilder code and it seems that any communication with the Oracle server has overhead where with Sybase there was little to none. This seems to be much more apparent or visible with sites on our WAN then when working from within the same building. As you can see below with our timing this is not a network issue and some people may think after my last line. It seems to be a problem between the Oracle client and server when using the PB native driver (7.3, the PB driver for Oracle 8 doesn't work. Without getting into too many details, we verified this with Sybase.)
Has anyone else had this problem. We are having a hard time believing that no one has ever migrated from a PB/Sybase to a PB/Oracle environment and not had problems with performance. We are seeing a 250% to 500% increase in time for all functions executed from a site on our WAN. Now please keep in mind that we are comparing these timings to Sybase communication over the WAN as well. So we are comparing apples to apples and therefore it doesn't seem to be a network issue. Please let me know if you have any advice. Thanks!
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 30 1998 - 18:16:36 CET