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

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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-2024 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.