Re: Sever pulling a bazillion rows from IBMi via JDBC (I think)

Hello Paul,

Am 03.09.2025 um 02:13 schrieb Paul Nelson <nelsonp@xxxxxxxxxxxxx>:

One should sort the data into the correct order ahead of time. This saves the remote the effort of maintaining the index database.

Depends. If the overall time to run all those steps is slower than pre-sort and insert, there's nothing to win.

I had to explain that the remote machine was working overtime to keep the index database in the proper order.

Interesting remark!

An even less resources wasting approach would have been to completely remove any indexes on the destination database, run the bulk inserts, and then create the desired index in one go. I presume creating an index from an existing table being more efficient than maintaining an index constantly with small changes happening very frequently.

:wq! PoC