[jboss-user] [EJB 3.0] - Re: 10,000 Recorc Per Second (In EJB 3.0)

snau2005 do-not-reply at jboss.com
Fri Apr 20 06:50:29 EDT 2007


Hi,
     Few month ago I made some test and achieved more than 5000/s inserts on average pc (actually there was 2 pc's in case with oracle, one with jboss another with oracleand 1 pcin case with postgresql, both resutls quite equal). These inserts was simple, dummy inserts. 
It's importat to set batch updates, can be 1000 or more


very important to switch off logging


use oci driver (in case with oracle)

also i used few threads (best speed with 8 threads, i thing this depends on pc (how many processors and so on)), everything was done i one transaction, also you can play with flush().


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4039208#4039208

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4039208



More information about the jboss-user mailing list