Re: using java for stored procedures (Thorbjoern Ravn Andersen) -- JAVA400-L

Subject: Re: using java for stored procedures (Thorbjoern Ravn Andersen)
From: Bruce Jin <brucej@xxxxxxxxxxxxxxxxxxxx>
Date: Thu, 26 Mar 2009 16:24:31 -0500
List-archive: <http://archive.midrange.com/java400-l>
List-help: <mailto:java400-l-request@midrange.com?subject=help>
List-id: Java Programming on and around the iSeries / AS400 <java400-l.midrange.com>
List-post: <mailto:java400-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/java400-l>, <mailto:java400-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/java400-l>, <mailto:java400-l-request@midrange.com?subject=unsubscribe>

Our past experience seemed to suggest that Java stored procedures
implemented on AS400 could be very slow compared with SQL/RPG/CL procedures.
Our tests showed that it could be 10 – 50 times slower. We did tests on
tables with a few dozen records to a few dozen million records. Tested on
V6R1.

It would be interesting to know if this is true on your box.

Bruce

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: using java for stored procedures (Thorbjoern Ravn Andersen) , Alan Campin

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.