Subject | Re: [Firebird-Java] Firebird in app server slow connection |
---|---|
Author | Roman Rokytskyy |
Post date | 2008-06-30T16:40:18Z |
> Here's the first part of the log messages, as you can see there is a 10That is not your only problem....
> second gap.
> [2008-06-30 16:12:28,408 AbstractFBConnectionPoolDataSource,DEBUG] Trying toThe "distance" between these two lines is construction of 2 classes
> create connection, total connections 0, max allowed 2
>
> [2008-06-30 16:12:28,408 AbstractFBConnectionPoolDataSource,DEBUG] Trying to
> create connection, total connections 0, max allowed 2
>
> [2008-06-30 16:12:37,584 AbstractJavaGDSImpl,DEBUG] Got socket
>
> [2008-06-30 16:12:37,584 AbstractJavaGDSImpl,DEBUG] Got socket
>
> [2008-06-30 16:12:38,146 AbstractJavaGDSImpl,DEBUG] user.name: SYSTEM
>
> [2008-06-30 16:12:38,146 AbstractJavaGDSImpl,DEBUG] user.name: SYSTEM
which allocate about 32k byte arrays.
From the log it took more than 0.5 seconds - either some big issue with
the performance of your system or the log items are not correct.
Anyway, try using the IP address instead of name - sometimes DNS brings
some delays if configured incorrectly.
As to the problem - at the moment I do not see anything that can be
tuned in JDBC driver to make it run faster... for me it looks like some
incorrectly configured JVM and/or OS.
Roman