Re: V7R5 SQL Engine Performance Issue

Rich,

This topic was discussed on this list just last month.   See:

   https://archive.midrange.com/midrange-l/202309/msg00275.html  ;

I suggest you start by reading the entire thread.

Hope that helps,

Mark S. Waterbury

On Monday, October 2, 2023 at 10:45:35 PM EDT, Rich Marion <dpcmarion@xxxxxxxxxxxxxxxxx> wrote:

I recently upgraded from V7R3 to V7R5 and noticed many of my SQLRPGLE program are now taking a super long time to complete.  The program stack points to the SQL EXEC or the FETCH statements.

Today, one program was doing a simply "Insert Into" with the "select" having
a "Group By" over a single table (no joins or subqueries).  It was supposed
to insert about 1.2 million records into a table that had over 700 million.
I let it run for 3 hours before I canceled it. It was adding about 25
records/second.

I manually executed the same "Select-Group by" and created a table with the 1.2 million records.  Then I wrote an Old fashion read/write program via
RLA.  This entire process took less than a half an hour.

Has anyone noticed performance issues with the V7R5 SQL Engine?

TIA

Rich