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



On 10/16/2001 at 09:45:10 AM, java400-l-admin@midrange.com wrote:
Is JDBC performance really that bad vs the competition?
--- end of excerpt ---

Warning, like Joe (but in the opposite direction), I'm very biased.
(I'm for JDBC).

Its not that JDBC performance is bad. We feel (native driver team)
that its very good,
Its that this system has had 20+ years of optimizing every
fricking bit twiddling instruction in the RPG/Cobol and
even static SQL I/O path.

You just can't spend that much time and resources on something
and not have it go really really fast. RPG/Cobol going really
really fast for some things does not mean its fast for all
things nor does it mean that JDBC is bad.

Our opinions are that you can spend some smarts optimizing
JDBC/SQL access and get very good performance.
EXPECIALLY, If you think in SQL, you design in SQL and your
coded around SQL for that level of portability.
In those cases, I'd use SQL and JDBC.

Joe's recommendation about abstracting data access so it
can be (transparently) implemented as RPG or Cobol or JDBC
or IFS or network based or qbits based (storage based on the quantum
properties of subatomic particles) is 100% correct.

I think then you make the underlying implementation:
1) What you have the skills for.
2) What's best from a maintenance/quality ease of modification perspective
3) What goes fastest

In any case (even if you choose JDBC), this abstraction encapsulates
you from changes in your data model and/or performance optimizations
you choose to make.
AGAIN, this is a good sell EVEN WHEN YOU USE JDBC.


In every single ethnic, religious or racial group, there are a
very few truly evil people. For each of those people there
are many, many, many good people.
Assuming anything (evilness or capability for evil) about the
particular group is bigotry and idiocy. Don't do it.  -- Me

Fred A. Kulack  -  AS/400e  Java and Java DB2 access, Jdbc, JTA, etc...
IBM in Rochester, MN  (Phone: 507.253.5982   T/L 553-5982)
mailto:kulack@us.ibm.com   Personal: mailto:kulack@magnaspeed.net
AOL Instant Messenger: Home:FKulack  Work:FKulackWrk



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.