Query taking lot of time to execute..

[asgardar]

Hi,
I have a very complecated query which I am executing using JDBC. The query has an insert statement. This query takes 15 mins to complete. I'm running the query as stand alone java program. Can some one have some suggestions what is the best way to debug. I need to find out why the query is taking that long. I'm using oracle 10g with sql developer.

ps = con.prepareStatement(query);
ps.setString(1,date);
ps.setString(2,code);
timeStart = System.currentTimeMillis();
ps.executeUpdate();
timeEnd = System.currentTimeMillis();

System.out.println("Time Taken::"+(timeStart -timeEnd)+" ms");

Thanks in advance
Ajoo

[masijade]

One single query or an entire set of queries. If a set, use addBatch and executeBatch, if a single query, then it can only be the network, or the db setup (bad keys/indexes or a very badly formed SQL statement), either one is not a Java problem.

[asgardar]

One question, when I run the same query using SQL cosole or TOAD it finishes faster. does this mean something is wrong with my code?

[JosAH]

Maybe changing this:

System.out.println("Time Taken::"+(timeStart-timeEnd)+" ms");

to this:

System.out.println("Time Taken::"+(timeEnd-timeStart)+" ms");

might help.

kind regards,

Jos ;-)

[masijade]

Ha! Didn't even look!