Re: RUNJVA performance question

<tim>
Hope this is the correct forum for this question.

I have a process where i read records from a table and call a java program using the runjva command. This process can evoke RUNJVA several thousand times.

Is there a performance issue doing it this way? Am i better off maybe calling the java program using RUNJVA once and having the java program read the iseries table run the process?

i know i can run a java program using EXTPROC(*JAVA also, but not sure again about perforance.
</tim>

Starting a JVM on as400 has lots of overhead and starting it for a small amount of work, you will produce > 90% of overhead for less than 10% of work to do.
Starting multiple JVMs in multiple job's, you will bring down your as400, if this would happen in all your jobs.

Both problems could be solved without java knowledge and without java programming or knowledge of JNI support of RPG.

- use commandgate, it's open source and provides an os400 command runjavarun, this will cutdown the runtime of short running RUNJVA from a couple of seconds to subsecond for each call.
- reading records from a table by JDBC, the better alternative would be to use ArdGate. It's installed and configured in less than 1 day and then you could read, write and update Oracle, MySQL, MS SQL Server and all other JDBC capable databases with embedded SQL in RPG, QMQRY and STRSQL.

Both solutionas are open source and available with AppServer4RPG at Sourceforge.

D*B