J
jacksu
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.
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.