Re: Data access across libraries

M
Hello Buck,

You wrote:
>When I mention writing custom "drivers" (not the right word, but the
>concept is there) for the iSeries database, I get the "why on earth would
>you want to re-invent the wheel?" look.  When I say "screaming performance"
>I get the "how can a hundred thousand dollar machine be slower than a two
>thousand dollar PC?" look.

Take a representative number of your files (master files, transactions,
history, etc.), stick them in the DB on the $2000 PC and have then run a
hundred simultaneous queries and updates against large numbers of records.
Then do the same on the $100,000 system.  I think you'll find that the
$100,000 system copes a lot better with the load -- but you knew that didn't
you?

>Is JDBC performance really that bad vs the competition?

No.  It's all relative.  JDBC (and SQL) for that matter are likely to be
slower than native access in many cases -- specifically record-at-a-time
processing.  If it makes sense to use JDBC for your architecture then do so.
Although I'm a firm believer in the idea that the data should be managed at
the database and that means few or no raw queries in client code, just SQL
CALLs to stored procedures.  I don't care if the stored procedures are SQL,
embedded SQL, or native I/O.  Certain stored procedures may not be portable
but then you chose your database for many reasons and portability should be
pretty low on the list.  Reliabilty, stability, scalability, and other
ilities are more important.

Regards,
Simon Coulter.

«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
«» FlyByNight Software         AS/400 Technical Specialists       «»
«» Eclipse the competition - run your business on an IBM AS/400.  «»
«»                                                                «»
«» Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\   «»
«» Fax:   +61 3 9419 0175   mailto: shc@flybynight.com.au   \ /   «»
«»                                                           X    «»
«»               ASCII Ribbon campaign against HTML E-Mail  / \   «»
«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»