Re: Performance between Oracle & Progress Database

Maybe you should dump Oracle and go with Progress.

This kind of attitude amazes me so often - you can see it working 
better, but the old gotta go with Oracle mindset comes into play.

It is like trying to push a chain.

Technically the answer is obvious - use a Progress database.  There is 
no bug.

Sam wrote:

> I had tested several connection types (with -S , with -RO, with -1) and I
> have the same bad performances.
>
> Moreover, I have contacted The Progress Hotline which says that there is
> pehaps a progress bug.
> The question is asked to the Progress developpers.
> I wait for more informations about it today.
>
> We tested our application 2 years ago and the application was 30% slower
> with Oracle 8i (progress 8) than progress 8.
> Today it is 100% !! something has chaged in Progress.
>
> Samuel
>
>
>
> Tom Bascom <[EMAIL PROTECTED]> a écrit dans le message :
> [EMAIL PROTECTED]
>
> > This test isn't very revealing.
> >
> > It could be a lot of things but given the nature of your test it's
>
> probably
>
> > just that there is an extra layer between your application and the code.
> >
> > Does your "pure progress" implementation happen to use self service
>
> clients?
>
> > (No -S connection parameter)  If it does then that's likely why you're
> > seeing much better performance.  It's hard to beat the shared memory
>
> client
>
> > for performance.
> >
> > Otherwise it could be just about anything.
> >
> > "samuel" <[EMAIL PROTECTED]> wrote in message
> > news:[EMAIL PROTECTED]
> >
> > > Hi all,
> > >
> > > All my application is written in Progress 4GL and run under the
> > > progress database.
> > >
> > > I Migrate my application to Oracle Dataserver without modifying my
> > > code (use the Schema Holder database)
> > > but I have poor performance under Oracle : Globally, Oracle twice
> > > slower than Progress.
> > >
> > > Code example in the sports2000 Progress Database:
> > >
> > > ===================================
> > > define variable e-time as decimal no-undo.
> > > define variable i as integer no-undo.
> > > define variable toto as CHARACTER no-undo.
> > >
> > > DISPLAY STRING(TIME,"HH:MM:SS").
> > > e-time = etime.
> > > do i = 1 to 10000 :
> > >   FOR EACH customer
> > >       where custnum = 1393
> > >       NO-LOCK  :
> > >   END.
> > > end. /* do */
> > >
> > > DISPLAY STRING(TIME,"HH:MM:SS").
> > >
> > > message etime - e-time ' ms' view-as alert-box.
> > > =====================================
> > >
> > > Under Progress Database : less than 1 second.
> > > Under Oracle Database : more than 12 seconds.
> > >
> > >
> > > Have you the same poor performance when you use this architecture
> > > (Schema Holder) with Oracle ?
> > > How can I have greater performance ?
> > >
> > > Thank you for your help
> > >
> > > Samuel