Thanks. I am actually already using the IP address. Do you have any inkling
for what the JVM or OS config problem might be?



Regards,



Rupert Young

Principal Architect

ReStart Consulting Ltd

Connecting the NHS

* UK: +44 1753 865879

* UK: +44 7795 480387

http://www.restartconsulting.com <BLOCKED::http://www.restartconsulting.com>


_____

From: Firebird-Java@yahoogroups.com [mailto:Firebird-Java@yahoogroups.com]
On Behalf Of Roman Rokytskyy
Sent: 30 June 2008 17:40
To: Firebird-Java@yahoogroups.com
Subject: Re: [Firebird-Java] Firebird in app server slow connection

> Here's the first part of the log messages, as you can see there is a 10
> second gap.

That is not your only problem....

> [2008-06-30 16:12:28,408 AbstractFBConnectionPoolDataSource,DEBUG] Trying

to

> 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

The "distance" between these two lines is construction of 2 classes
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





[Non-text portions of this message have been removed]