Re: Performance between Oracle & Progress Database

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
>
>