Subject Re: [Firebird-Java] Re: Understanding memory for each connection under classic architecture
Author Roman Rokytskyy
> Thanks for your comments, and thanks for a great package. I have used Jaybird for many years and find it very dependable and quick. This is the first time I have noticed a difference between Jaybird and ISQL.


> The connection through ISQL is on the same host, 'connect localhost:CBASE' where CBASE is in the aliases.conf file. The connection string through JDBC is, 'jdbc:firebirdsql:localhost/3050:CBASE' with no connection parameters.

Hmmm... now that is strange. Could you please try running isql and Java
application from a remote host capture the connection pakets using
Wireshark and send me the dumps?

> Regarding the buffers -- as this is a read-intensive, not update-intensive application, it sounds like the 2048 buffers should not cause a problem, right?

I have seen recommendations from developers about 1024 or 2048 buffers
for classic on the modern HW (also, IIRC, the default for classic will
be changed in 2.5). So that is not that unusual.