Hi,all,
I am doing a project which upload a file and then insert the parsing result into
the DB(Oracle 9i). The situation is like this,there's main lineitem table and another
2 dependent tables,Each mainline will have a couple of vlaues to be inserted in the
dependaent tables.
The observation is that jboss will lauch select and insertion queries 1000 times if
there's 1000 mainline to be inserted.meanwhile jboss will insert many times for
each lineitem dependent value to those dependaent tables.So the performance is not
that good:almost 0.3sec/per lineitem.
The statisitcs are as follows:
Total number of mainline from file parser to be put into DB: 923,
Total Number of DB insertion operations:8359
Total Number of related DB query operations:9317
Total time to complete transaction:209secs
I was trying to improve the performance for jboss,but it seems like most
optimization is fordata loading(e.g read ahead ect..),so any good suggestion on
improving performance for data updating using CMP?
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3844039#3844039
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3844039
-------------------------------------------------------
This SF.Net email is sponsored by OSTG. Have you noticed the changes on
Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now,
one more big change to announce. We are now OSTG- Open Source Technology
Group. Come see the changes on the new OSTG site. www.ostg.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
