Re: PB + Oracle 8.0.5 = Poor Performance

There was some discussion in the Powerbuilder forums about this.

I'm quoting from an posting written by a Sybase employee:

In powersoft.public.powerbuilder.database "Dan Skibba" <skibba_at_sybase.com> wrote:

>The 6.5 version of the OR8 driver contains fixes to all major problems
>discovered with the 6.0.00 beta version. This driver is, however, is only
>compatible with Oracle 8.0.03 client. If you are using 8.0.04 or greater,
>you will need to use the O73 driver (in conjunction with the 7.3.XX Required
>Support Files from Oracle).
>
>Also, technical document 47763 ("PowerBuilder and Oracle8) address the
>various Oracle8 features and which are supported by the PB native Oracle 8
>drivers.

The technical document refered above is at:

http://techinfo.sybase.com:80/css/techinfo.nsf/DocId/ID=47763

In other articles, people have complained about slow performance, cause by the PB driver failing to close the cursor after a DW retrieve.

So, try using a different native driver, presumably the PB060O73.DLL

Andrew Schonberger

On Mon, 30 Nov 1998 17:05:32 GMT, cjoe125_at_my-dejanews.com wrote:

>Hi, colleagues!
>
> I recently installed Oracle 8.0.5.0.0 on Sun Enterprise Server 450 with
>Solaris 2.6 and moved data from Oracle 7.3.2.2.0 database on HP 9000 with
>HP-UX 2.0B. The new Sun Server is much more powerful. So, with sqlplus, I
>compared results from these two machines and found that queries ran much
>faster in Oracle8 in the Sun box than in the HP. However, when I tested with
>application programs written by PowerBuilder, I got much poorer results from
>Oracle 8 on Sun. The application ran at least ten times slower connecting to
>Sun than to HP. I've tried Net8 and Sqlnet 2.3 as well as PowerBuilder
>5.0.4, 6.0 and 6.5. The results were similar.
>
> After I spent almost a month's time on testing, I have to obtain the
>conlusion: Oracle 8 is not the suitable backend for PB, at least for the
>applications in our Co.
>
> One thing I should mention here is: the applications I tested with were
>originally developed with PB 5.0.4 and they were migrated to PB 6.0 and 6.5
>when I did further testing, respectively. The applications with PFC in them.
>
> Shearson Li DBA IPC Information Systems, Inc.
>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Dec 07 1998 - 06:48:47 CET