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



Hello,

> PreparedStatement pstmt_select = ca.prepareStatement
>     ("SELECT LWHS, LLOC, LPROD, LLOT, (LOPB - LISSU + LADJU + LRCT -
> LIALOC), LOPB, LISSU, LADJU, LRCT, LIALOC FROM " +
> as400Library + ".ILI");

One thing I have noticed, contrary to the normal belief, is that prepared 
statements are some times slower than re-building the SQL statement.

One recent project on Windows2K using SQL7, individual "insert into's" where 
10x *faster* than using a prepared statement and I was just changing the data. 
I was testing as we had records to add to the same table (about 20 odd fields) 
and in this case a prepared statement was worse.

I finally implemented it using bulk loading, which is lightening fast...

108000 records
-  prepared statement takes about forever
-  individual inserts takes about 7 mins
-  bulk loading takes about just over a minute

--phil


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.