Re: Performance SQL Delete vs RPGLE Delete

[Charles Wilt <charles.wilt@xxxxxxxxx>]

SQL would be faster...

However, assuming a 7.2+, use the TRUNCATE statement...

TRUNCATE MYTABLE
  DROP STORAGE
  IMMEDIATE;


On Thu, Nov 19, 2020 at 3:25 PM K Crawford <kscx3ksc@xxxxxxxxx> wrote:

> I know the normal answer is, depends.  Just looking for thoughts.
>
> I have a program (RPGLE) that has this code (the file has a lock on it
> otherwise we would use CLRPFM or some other method).
>
>   Read FileA;
>   Dow not %eof(FileA);
>      Delete FileAr;
>      Read FileA;
>   Enddo;
>
> How would the performance compare to SQL with something like, in that same
> RPGLE program.
>   Exec SQL Set option Commit=*None
>   Exec SQL Delete From FileA;
>
> FileA will have 0.5 - 6 million rows.
> --
> Kerwin Crawford
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com