Re: Performance between Oracle & Progress Database

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