Hi all,
i'm developing a CAA (Computer Aided Assessment) application with Struts,Hibernate,Jboss,Firebird database. i tested my application, simulating a University exam test with about 45 students, and all gone very slow. So i've noticed that i used hibernate default connections pool manager with these parameters :
hibernate.connection.pool_size = 1
hibernate.statement_cache.size = 25.
Is this the cause of slow perfomance of my application? i tried to substitute the hibernate default connections pool manager with c3p0 library, and set c3p0 properties:
hibernate.c3p0.min_size=15
hibernate.c3p0.max_size=50
hibernate.c3p0.timeout=1800
hibernate.c3p0.max_statement=50
Can anyone tell me what values of these properties are good for my application?
thanks to all for attention, and sorry for my english :-)

Don't use hibernates built in connection pool for production - only test. In anycase, have just one connection is not great for concurrent processing (eg it cannot do any).

C3PO is a fine connection pool - settings are dependent on concurrent access requireemnts and balancing memory use etc. You configuation you had shown should be fine as a starting point.