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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...