[
https://issues.apache.org/jira/browse/ODE-495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12665670#action_12665670
]
Shammy Chen commented on ODE-495:
---------------------------------
Compared to ActiveBpel, ODE does persist more information to database, that's
perhaps the why of ActiveBpel performs better than ODE even if it still uses
axis instead of axis2, it has less tables than ODE and less data to persist.
But in our multi-threaded load test, our oracle can do at least 6000
transactional insertions per second(almost reaches its write bandwidth limit) ,
when we persist data from ODE we can neither make oracle's CPU to be exhausted
nor make its IO to be exhausted, there must be something that slows ODE down,
perhaps JPA(and TransactionManager), or VPU.
Now I am rewrting TEMPO using JDBC(and also made many other modifications) to
see the effect, after that I will try to implement JDBC DAO and do load test
again.
> Implement ODE DAO directly by JDBC instead of JPA(OpenJPA) as a choice to
> improve performance dramaticly
> --------------------------------------------------------------------------------------------------------
>
> Key: ODE-495
> URL: https://issues.apache.org/jira/browse/ODE-495
> Project: ODE
> Issue Type: Improvement
> Components: BPEL Runtime
> Affects Versions: 1.2
> Environment: JAVA 5.0+
> Reporter: Shammy Chen
>
> Recently I've been testing ODE and tempo(modified) thoroughly, but it
> performed not too good, actually our customers even refuse to use it since
> their trades greatly exceed ODE's throughput. I am trying to make it perform
> better, and I tried many ways, filter ODE enevts,increase ODE-Server threads,
> increase database connections, increase integration layer threads, still it
> performs under our(customer's) expectation.
> Then I tried to use memdao to see what makes ODE slow down, I found memdao
> run at least 7~8 times faster than jpadao.So I deduce that database operation
> is critical to performance.We have two ways to solve this problem, do less
> database operations or make the operation faster(or both).Then I did a
> comparision between OpenJPA and JDBC,and I found JDBC perform almost ten
> times better than OpenJPA . Our clients don't care how we implement the
> system at all,what they really care is how good the system fulfills their
> business goals,what they really care is the system's stability and
> performance.Can we implement ODE DAO by JDBC to improve performance?
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
