Subject Re: [Firebird-Java] Driver too slow.
Author Carsten Schäfer
1 update:
I noticed that the javaw-process of my application consumes about 99% cpu-usage most of the time. I think, normaly ibserver should get most cpu-time.


----- Original Message -----
From: "Carsten Schäfer" <ca_schaefer@...>
Newsgroups: egroups.ib-java
Sent: Monday, April 15, 2002 8:00 AM
Subject: [Firebird-Java] Driver too slow.

> 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 ?)