[EMAIL PROTECTED] wrote:

> Thank you a lot for info!
> 
> Can you give some estimates about the performace? I've conducted small test
> on my PC (Pentium III 550 MHz, 256 Mb RAM) using jboss and Hypersonic SQL. I
> get:
> 
> creating 100 beans - approx. 5000 ms
> updating 100 beans - approx. 5000 ms
> deleting 100 beans - approx. 8000 ms
> 
> Taking into consideration, that Hypersonic SQL (basically in-memory Java
> DB), this performance is more or less acceptable for us. However, file based
> tests for InstantDB show 3-4 times slower performance, and PostgreSQL 6.5.2
> (ok, not 7.1) - 20 times slow down, and such performance is definitelly
> unacceptable.

Is this CMP or BMP? We're focusing on CMP performance in version 2.3.
How are the transactions written? Do you call multiple methods from a 
client, or are you using session wrappers, or is each transaction one 
method inherently?
Do the update and delete call a finder then loop through the resulting 
collection, or do the call individual findByPrimaryKey()s?

Also, if you can try Postgres 7.1, it should be much faster for various 
reasons.

-danch


_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to