Re: JDBC and SQL Performance Under V5R3

[EDoxtator <doc6502@xxxxxxxxx>]

Colin:

>what sort of stuff are they doing with the java? Its difficult to see where
>the performance issues are without more details?

They've got a set of apps which do single and multi-row updates, fetches, and
inserts (depends on the application).

>For very large volumes of data, they should be using the fastest thing
>possible. For database access, that is going to be well designed RPG
>programs.

Exactly.  However, my client is a Synon shop.  A very old version of Synon is
in play, and there's absolutely no way of shifting them.  The code Synon
generates isn't terribly efficent-- I realize that's a bottleneck.  However,
it's a bottleneck I cannot overcome.  So, I was hoping to focus on the SQL
side-- I can probably convince them to upgrade.

Thanks

-Ed