Subject | Driver too slow. |
---|---|
Author | Carsten Schäfer |
Post date | 2002-04-15T09:57:42Z |
Hi,
this morning i downloaded the up to date src from cvs.
I'm using Sun JDK1.3.1_03 on Win2000SP2 with firebird 1.0 relaese.
Before this morning i used the driver version send to me from Daniel Marczisovszky.
With the version from Daniel i noticed that my application start was about 2 times slower than with Interclient 2.01.
Now with the new build it takes about 5 times longer than with IC.
This is far too much.
At serverstart I only have 1 connection.
I get it like this:
App_Server.dbProperties = new Properties();
App_Server.dbProperties.put("user", "user");
App_Server.dbProperties.put("password", "pass");
App_Server.dbProperties.put("lc_ctype", "WIN1252");
Class.forName("org.firebirdsql.jdbc.FBDriver");
Connection con = DriverManager.getConnection("jdbc:firebirdsql:localhost/3050:e:\dbname.gdb",App_Server.dbProperties);
(I've turned logging of by removing the logging-jar. Is this the right way ?)
I'm doing abot 30 simple PreparedStatements with this connection, like this:
PreparedStatement anfrage = con.prepareStatement("SELECT * FROM t_Kunde WHERE f_active = ? AND id_kunde > 0");
anfrage.setBoolean(1, true);
ResultSet rs = anfrage.executeQuery();
f_active and id_kunde are integer field in the database.
My tables have between 5 and 80 columns.
Does somebody have an explanation for this slow behaviour (even slower than with my last tests)?
Is there a chance to improve the speed ?
(Another Q:With IC i used a datasource for connection creation. Can i use something like this with the pure Java-driver, too ?)
gruse
Carsten
this morning i downloaded the up to date src from cvs.
I'm using Sun JDK1.3.1_03 on Win2000SP2 with firebird 1.0 relaese.
Before this morning i used the driver version send to me from Daniel Marczisovszky.
With the version from Daniel i noticed that my application start was about 2 times slower than with Interclient 2.01.
Now with the new build it takes about 5 times longer than with IC.
This is far too much.
At serverstart I only have 1 connection.
I get it like this:
App_Server.dbProperties = new Properties();
App_Server.dbProperties.put("user", "user");
App_Server.dbProperties.put("password", "pass");
App_Server.dbProperties.put("lc_ctype", "WIN1252");
Class.forName("org.firebirdsql.jdbc.FBDriver");
Connection con = DriverManager.getConnection("jdbc:firebirdsql:localhost/3050:e:\dbname.gdb",App_Server.dbProperties);
(I've turned logging of by removing the logging-jar. Is this the right way ?)
I'm doing abot 30 simple PreparedStatements with this connection, like this:
PreparedStatement anfrage = con.prepareStatement("SELECT * FROM t_Kunde WHERE f_active = ? AND id_kunde > 0");
anfrage.setBoolean(1, true);
ResultSet rs = anfrage.executeQuery();
f_active and id_kunde are integer field in the database.
My tables have between 5 and 80 columns.
Does somebody have an explanation for this slow behaviour (even slower than with my last tests)?
Is there a chance to improve the speed ?
(Another Q:With IC i used a datasource for connection creation. Can i use something like this with the pure Java-driver, too ?)
gruse
Carsten