Subject | Re: [Firebird-Java] Firebird in app server slow connection |
---|---|
Author | Roman Rokytskyy |
Post date | 2008-06-26T09:57:15Z |
> For the parameters min_size, max_size of 5 and 30 it takes over 2 minutesIn general it is strange. Obtaining a connection to Firebird takes
> and for 1 and 10 it takes about 25 secs. Any idea why this is so long?
milliseconds, seconds at most. The test suite for Jaybird is executed
less than in 6 minutes and it creates database, obtains connections,
executes tests, closes the connection and drops the database about 500
times.
> Here's the code I am using,...
>
Do you close your connection that you have obtained using the
Connection.close() method?
In general try logging on the INFO level - you would see getting the
connections from the pool:
http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=config:logging
Roman