Re: powerbuilder in rbo and multiple constraint question...

2004-01-16 Thread chris
Chris, I've worked on a large Powerbuilder App for a number of years. We used CBO all the time under 7.3.2, 7.3.4 and 8.1.7. You're right Powerbuilder per se requiring RBO is rubbish. Cheers, Chris Dunscombe Quoting Chris Stephens <[EMAIL PROTECTED]>: > I'm working with a 3rd party vendor

Re: powerbuilder in rbo and multiple constraint question...

2004-01-15 Thread Mladen Gogala
On 01/15/2004 09:54:36 AM, Chris Stephens wrote: > There response was that it's a limitation of powerbuilder. I don't buy that > for a second. ...anyone know for sure? I have slight experience with supporting Powerbuilder apps in 1996 and, later, in 1998. At that time it was completely possibl

Re: powerbuilder in rbo and multiple constraint question...

2004-01-15 Thread Ryan
Powerbuilder is a GUI. just like forms. This is what typically happens with 3rd party apps. They develop them some time in the past. Oracle adds new features, they dont want to spend the money to test to see if it works. So they tell customers not to use them. Its how they keep costs down. New deve

RE: powerbuilder in rbo and multiple constraint question...

2004-01-15 Thread Kevin Toepke
try again... -Original Message- Chris I know from a previous assignment that PowerBuilder has no issues running queries against a database using the CBO. In fact, PowerBuilder doesn't give a rats backside what the database does to the query as long as it returns what's expected. As for "

RE: powerbuilder in rbo and multiple constraint question...

2004-01-15 Thread Kevin Toepke
Chris I know from a previous assignment that PowerBuilder has no issues running queries against a database using the CBO. In fact, PowerBuilder doesn't give a rats backside what the database does to the query as long as it returns what's expected. As for "redundant" constraints, they will increas

powerbuilder in rbo and multiple constraint question...

2004-01-15 Thread Chris Stephens
I'm working with a 3rd party vendor to resolve some performance issues with there call center app. The app is written in PowerBuilder. When I traced the offending sessions, I noticed the queries are being run under the rbo. When I run those same queries under the cbo the response time is dramatic