Re: query taking long time from java code

From: NitelyJoy <nitelyjoy_at_ist-einmalig.de>
Date: 26 Aug 2006 02:12:46 -0700
Message-ID: <1156583566.639673.283750@p79g2000cwp.googlegroups.com>

This is because TOAD gives out the first rows as soon as they are fetched. Your query in TOAD takes as long as in java, if you wait for all result rows.

Do a

select count(*) from (
<your_query>

);

in TOAD. Here, oracle must wait until all rows are fetched to calcucate the count.

I think you have to implement paging in your java app. Pages that show lines 1-20, 21-40,... and so on. In your java code, you should do something like:

select * from (
<your_query>

) where rownum <= 20; Received on Sat Aug 26 2006 - 04:12:46 CDT