Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Java > Performance issue in multi-level Oracle Object/thin JDBC Options Options

Reply
Thread Tools

Performance issue in multi-level Oracle Object/thin JDBC Options Options

 
 
jacksu
Guest
Posts: n/a
 
      10-09-2007
Hi All,

We are trying to call Oracle 9i Stored Procedure with ThinJDBC, the
parameter in Stored procedure is multilevel object:


Table of Object1
+------- Object1
+------ Table of Object2
+------ Object2
+----- attribute in
simple oracle types, such as varchar.


The query for that call is very light way, just get two records from
a
hundred records table. But the whole execution time is around 600ms
to
1000ms.


If we change to one level Oracle Object


+---- Object
+------- attributes


with the same query data, the execution time is around 100 ms.


I am wondering where to start to troubleshoot the performance
problem,
500 ms is not acceptable in the production environment.

We checked the stored proc elapse time, very minimum, less than 10 ms.
So seems most of the time is in JDBC side. Any suggestion to
troubleshoot JDBC performance issue?


Thanks in advance.

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
CLOB issue with JDBC, IBATIS and Oracle 10g kartechy@googlemail.com Java 1 09-21-2007 11:06 AM
stand-alone JMS, other JDBC operations, and transactions ( ActiveMQ + JOTM + JDBC operations ) Jesus M. Salvo Jr. Java 2 02-11-2006 06:33 PM
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/DynaLoader.pm line 230. Feyruz Perl Misc 4 10-14-2005 06:47 PM
oracle.jdbc.OracleDriver vs oracle.jdbc.driver.OracleDriver Betty Java 1 05-21-2005 05:15 PM
Re: jdbc help:sun.jdbc.odbc.JdbcOdbcDriver Keith Wansbrough Java 0 08-16-2004 07:31 PM



Advertisments