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
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
