Hi,
after some tests i also found out that type-4 driver is about 2 times slower with selects in comparison to Interclient 2.01.
I'm only doing "select * from " different tables with Statements or PreparedStatement and reading out between 3 and 80 colums.

Im using JDK1.3.1_03 on Win2000SP2 with Firebird 1.0.

I'm using something like this to get my connection:

App_Server.dbProperties = new Properties();
App_Server.dbProperties.put("user", "xxx");
App_Server.dbProperties.put("password", "yyy");
App_Server.dbProperties.put("lc_ctype", "WIN1252");
Class.forName("org.firebirdsql.jdbc.FBDriver");

DriverManager.getConnection("jdbc:firebirdsql:localhost/3050:e:/datenbanken/dbams_test.gdb",App_Server.dbProperties);

Only 1 Connection. App_Server and Firebird on the same machine.

gruse
Carsten