openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Dick (JIRA)" <j...@apache.org>
Subject [jira] Commented: (OPENJPA-558) Performance difference between Oracle and Sql server of a factor 2 to 3
Date Fri, 04 Apr 2008 13:47:27 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12585527#action_12585527
] 

Michael Dick commented on OPENJPA-558:
--------------------------------------

Do you see the same behavior if you use JPA? The attached zip file contains a JDO testcase,
which we can't run with OpenJPA. The JDO persistence "persona" is only included with BEA's
Kodo.  

BEA developers do monitor this forum and may be able to run the provided example, but it might
be easier / quicker to fix if you had a JPA program which shows the same behavior. 

> Performance difference between Oracle and Sql server of a factor 2 to 3
> -----------------------------------------------------------------------
>
>                 Key: OPENJPA-558
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-558
>             Project: OpenJPA
>          Issue Type: Improvement
>         Environment: Kodo 4.1.4 (sql server 2005, Oracle 10, Oracle 11, ojdbc6 oracle
driver)
>            Reporter: Christiaan
>         Attachments: Oracle Performance.zip
>
>
> I am trying to include support for Oracle in our product. It currently supports ms sql
server. One of the things I noticed is that many of our unit tests perform a factor 2 to 3
slower. I managed to isolate one of the performance bottlenecks which is included in the attached
testcase. The persistent class is basically a 1-to-many relation with itself. The performance
bottleneck is for the code being executed on getParent(). On my machine it gives the following
output:
> 				============Executing test for Oracle=============
> 				There are now 1110 components
> 				Getting 1110 parents took 453ms
> 				Getting 1110 parents with direct SQL took 156ms
> 				============Executing test for SQL=============
> 				There are now 1110 components
> 				Getting 1110 parents took 156ms
> 				Getting 1110 parents with direct SQL took 156ms
> Note, for both sql server and oracle I didn't do any performance tuning. One thing to
note is that Oracle doesn't generate join syntax (which is probably related to issue openjpa-541).
I tried setting fetchConfig.setJoinSyntax(JoinSyntaxes.SYNTAX_SQL92), but this didn't have
any effect. However, executing the "and" syntax version versus the join syntax version with
direct sql gives a time difference of 176 ms vs 156 ms. So this doesn't really explain the
performance difference. I also tried a different oracle driver (datadirect) but this didn't
give much difference either. Could this performance difference be caused by openjpa code?
Did anyone encounter this as well?

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message