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