Re: PowerBuilder application preformance
Date: Fri, 19 Feb 2010 10:32:21 -0500
Message-ID: <20100219103221.wb2zddc204cgs80s_at_www.templarstable.com>
The development team here has experienced something similar. They are on an old version of Powerbuilder and Oracle 9205, but compiling with Oracle 10.2 libraries. A complete mess of non-compatible software, but that's another story...
We found that when Powerbuilder connects using some sort of optimizer string set to Rule, everything is fine. When it is set to Choose (those are the only two options in the old version of Powerbuilder we have) everything goes down the toilet. No change occurs to the explain plan or the performance in the database. Something is happening between / within Powerbuilder and ODBC. I had to wonder 'Why would anyone deploy an enterprise application on Powerbuilder?', but that isn't going to change. They haven't been able to figure out what is going on yet. If that helps, and you figure out what is going on, please let us all know.
Joel Wittenmyer
Manager, Enterprise Data Architecture
> I have an application developed in PowerBuilder and connects to
> Oracle 10.2.0.4. I have a data window in the app that has a master
> window on it and sub windows below it. When a user clicks the row in
> the window on the top half of the screen, the details of the record
> appears in the lower 2 windows. All works fine except slow.
>
> After upgrading to the 10 and/or 11 windows oracle client the
> response time for the detail record performance has doubled. With
> each upgrade, we changed the ora8 in the ini files to ora10 or
> ora11. We traced the timing of the calls and building of the sql on
> the back side. So we tried to adjust the versions of the Sybase
> drivers that were being called. By using the ora8 in the ini file we
> were using, performance is ideal was fine.
>
> Has anyone else experienced this?
>
>
> LeRoy Kemnitz
> UW System Administration
> Database Administrator
> 780 Regent Street, #246
> Madison, WI 53714
> Phone: (608) 265 -5775
> Fax: (608) 265 - 2090
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 19 2010 - 09:32:21 CST