Re: RPGLE Converted into SQL having performance issue

[Gad Miron <gadmiron@xxxxxxxxx>]

Hi Charles

Got a " This content is blocked. Contact the site owner to fix the issue "
when clicking the link
Is it only me ?

Gad



> date: Tue, 15 Dec 2020 08:20:13 -0700
> from: Charles Wilt <charles.wilt@xxxxxxxxx>
> subject: Re: RPGLE Converted into SQL having performance issue
>
> Not really surprising, you've replaced one access method with another that
> has more overhead.
>
> You can't simply replace RPG 1 record-at-time with SQL 1 record-at-time.
> Better off to stick with RPG.
>
> Used properly, SQL is faster than RPG.  But you have to use it properly;
> which means working with SETS of records.
>
> - unless there's no other option, don't use cursors.  (Display & printing
> they are required)
> - if using a cursor, read in blocks of records (100+)
>
> You might find this presentation I gave a few years ago helpful..
>
> https://www.linkedin.com/posts/charles-wilt-2a4a303_sql-for-the-rpg-developer-activity-6641756015354355712-woZR
>
> Charles
>
> **********************************