Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: select * performance
spool the sqlplus to a file and don't display it on the screen. Also
experiment with the array interface (I would think Java would suppor them -
fetching 100 rows at a time).
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "Susan Lam" <susana73_at_hotmail.com> wrote in message news:7186ed56.0302051759.25e37114_at_posting.google.com...Received on Wed Feb 05 2003 - 20:10:00 CST
> I have a small table with 10k record and 2M in size. The java
> application needs to pull out everything from this table and display
> it on the interface. This means, we are doing "select * from table"
> through jdbc. The application consistently takes 30 seconds to load.
>
> If I do a "select * from table" in sqlplus it does take 30 seconds to
> retrive everything but since it's mostly waiting on the display this
> test is not accurate. A tkprof result of "select * from table" shows
> that cpu/elapse time takes only around 1 second (mostly on fetching
> part obviously). Is there any other overhead on the database side?
> Can I say the rest of 29 seconds are on the application side trying to
> retrieve and display the data? We are trying to resolve this
> performance issue and I just want to eliminate the possibility of any
> more delay(beside that 1 second) on the database side.
>
> Thanks in advance,
> Susan