Subject Re: [Firebird-Java] Firebird JDBC is very slow
Author Blas Rodriguez Somoza
Post date 2002-08-31T11:31:31Z
Hello
 
    First please get the current version from CVS or get a Snapshot from yahoogroups. There are significative performance improvements since beta-1.
 
    About your numbers, when you work from console you don't create connections, and probably this is the point when most of the time is expended.
 
    To compare the performance using console a Java you must measure only the time in the query.
 
Regards
Blas Rodriguez Somoza
----- Original Message -----
Sent: Saturday, August 31, 2002 1:25 PM
Subject: [Firebird-Java] Firebird JDBC is very slow

Hi all,

 

I was using firebird-jca-jdbc-driver  1.0-beta-1 doing this query:

SELECT      MO.OBJECT_ID,

MO.LOCALE_ID,

MO.OBJECT_NAME,

            MO.OBJECT_VALUES,

MO.OBJECT_TYPE_ID,

MOT.OBJECT_TYPE_NAME

FROM        M_OBJECTS MO,

M_OBJECT_TYPE MOT

WHERE       MO.OBJECT_TYPE_ID = MOT.OBJECT_TYPE_ID

AND   MO.OBJECT_ID NOT

IN (  SELECT      DISTINCT MO.OBJECT_ID

FROM        M_OBJECTS MO,

M_OBJECT_TYPE MOT,

M_CONTENTS MC

                  WHERE       (MO.OBJECT_TYPE_ID = MOT.OBJECT_TYPE_ID

                        AND   CAST(MC.CONTENT_ID AS VARCHAR(255)) = MO.OBJECT_VALUES)

                        AND   MO.LOCALE_ID = ? )

      AND   MO.LOCALE_ID = ?

 

When I did from console, it only took about 290 ms. But, when I did query from Java, it took about 4 secs.

I was using Poolman from CodeStudio (www.codestudio.com) for the connection pooling.

 

Can someone tell me where the bottleneck is?

Is it on the casting of string to integer?

Is it on the query?

Is it on the JDBC?

Is it on the Poolman?

 

 

 

Thank you and regards

Ardhy



To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.