Hello, The problem we have concerns using JBossMQ with Oracle jdbc2 persistent store. We are suffering from very poor performance in such configuration. In manual transaction management calling Session.commit() method takes from about 50ms (for very small messages - ~100 bytes) to over second (for still small but a bit bigger messages - ~ 5 Kbytes).
If we switch to NullPersistenceManager or even jdbc PersistenceManager but using HSQLDB instead of Oracle, performance is *much* better (commit is at least ten times faster). Turning transactions off (using AUTO_ACKNOWLEDGE acknowledge mode) does not help much. We guess that problem is connected with poor performance of BLOB handling in Oracle jdbc driver, but we may be wrong. Are we suffering from common problem, or we've just screwed something up in our configuration? If it is just slow with Oracle and nothing can be done, what other mature (not HSQLDB) database for JMS store do you suggest. Our system configuration is: * JBoss AS 4.0.2 * java -version java version "1.5.0_05" Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_05-b05) Java HotSpot(TM) Server VM (build 1.5.0_05-b05, mixed mode) * uname -a SunOS ****** 5.9 Generic_118558-10 sun4u sparc SUNW,Sun-Fire-480R * Oracle 9.2.0.1.0 * the AS and Database are running on the same machine * we tried both OCI and thin driver for Oracle9i. Thank you in advance View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3901102#3901102 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3901102 ------------------------------------------------------- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
