query taking long time from java code

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 (

);

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 (

) where rownum <= 20;

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 (

);

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 (

) where rownum <= 20;

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 (

);

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 (

) where rownum <= 20;

Hi,
Thanks for the reply. I will try this out. However I am not using
pagination. I am trying to get a product list from database which has
got 15+ million records. And the number of rows returned from the
search are only 5-10...
Thanks,
Palak.

NitelyJoy wrote:

> 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 (
>
> );
>
> 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 (
>
> ) where rownum <= 20;

Hi,
Thanks for the reply. I will try this out. However I am not using
pagination. I am trying to get a product list from database which has
got 15+ million records. And the number of rows returned from the
search are only 5-10...
Thanks,
Palak.

NitelyJoy wrote:

> 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 (
>
> );
>
> 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 (
>
> ) where rownum <= 20;

Hi,
Thanks for the reply. I will try this out. However I am not using
pagination. I am trying to get a product list from database which has
got 15+ million records. And the number of rows returned from the
search are only 5-10...
Thanks,
Palak.

NitelyJoy wrote:

> 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 (
>
> );
>
> 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 (
>
> ) where rownum <= 20;

perhaps posting the relevant section of your java code might help us.

--

Niall Litchfield
Oracle DBA
http://www.orawin.info/services/

perhaps posting the relevant section of your java code might help us.

--

Niall Litchfield
Oracle DBA
http://www.orawin.info/services/

perhaps posting the relevant section of your java code might help us.

--

Niall Litchfield
Oracle DBA
http://www.orawin.info/services/