RE: odbc/jdbc question

John,

To me comparing Java running outside the db against PL/SQL doesn't make much sense because they are different. I would compare Java Stored Procedure
against PL/SQL for that purpose.

Now comparing Java against C make sense. And C using OCI will beat Java using JDBC. JDK 1.1.8 is really old and as you found out 1.3 is much faster.
And 1.4 is faster than 1.3.

As far as the performance between JDBC Thin and OCI driver, it's not a clear cut. It really depends on what you are doing. Like you find out in your situation Thin is faster than OCI.

Just my 2 cents.

Have a good weekend.

Richard Ji

-----Original Message-----
Sent: Friday, August 23, 2002 4:10 PM
To: Multiple recipients of list ORACLE-L

Dennis,

No, your first sentence is of course correct and does not show a misunderstanding. .

However, this was in a project where the use of Java was mandated by the architecture. Running on the server, a Java program performing the same test INSERTs as a C or PL/SQL program completed much slower. Further investigation seemed to point to an issue with data marshalling in the JDBC drivers. The Java code was presenting data fast enough, and the database was ticking over waiting for something to do.

The test code was to simulate a part of the system doing a high number of INSERTs.

Raised a TAR with Oracle to make sure we weren't doing anything wrong but it was never satisfactorily resolved.

Also found that, contrary to some Oracle documentation, the JDBC thin drivers were faster than the JDBC OCI8 driver. Also found that the JDK version appeared to matter. JDK 1.3.1 was much faster than JDK 1.1.8 which was significantly better than JDK 1.1.7.

Sorry, but I may have overstated the effect - may have been 100% instead of 100 times.

Cheers,

John Thomas

In message <F001.004BE265.20020823071352_at_fatcity.com>, DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> writes
>John
> You've lost me on the relevancy. PL/SQL executes within the database so
>in theory should run magnitudes of time faster than ODBC/JDBC. C is a
>programming language, so presumably you are using Pro*C or OCI to interact
>with the database. Again, your C program can execute on the server, thereby
>avoiding network delay, and again, running magnitudes faster than
ODBC/JDBC.
>The point is that you need to use whatever tool is appropriate to your
>situation. If the goal is to allow a Java program to interact with Oracle,
>then that limits your options. Let me know if I've misunderstood your
>comment.
>
>Dennis Williams
>DBA
>Lifetouch, Inc.
>dwilliams_at_lifetouch.com
>
>In message <F001.004B2243.20020812120824_at_fatcity.com>, Joe
>Armstrong-Champ <Joseph.Armstrong-Champ_at_tufts.edu> writes
>>We are running Oracle 8.1.7 on AIX. Our users want to use ODBC & JDBC
>>products to connect to the database. Are there any security issues we
>>should know about? Any other issues?
>>
>>Thanks.
>>Joe
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>
>--
>John Thomas Tel: 01506 881 037
>Oracle Contract DBA Mobile: 07986 182 368
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: John Thomas
> INET: oracle_at_toronto.demon.co.uk
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 
John Thomas                                     Tel:    01506 881 037
Oracle Contract DBA                             Mobile: 07986 182 368
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Thomas
  INET: oracle_at_toronto.demon.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ji, Richard
  INET: Richard.Ji_at_MobileSpring.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).