Re: select * performance

Susan Lam wrote:

> 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

I'd like to challenge the contention that any user has ever looked at 10K records. The delay is likely network and JDBC but I would start be reconsidering the design decision that decided to bring back more than two screen full of records at once. I would suggest to you that it may be in need of serious reconsideration.

Daniel Morgan Received on Wed Feb 05 2003 - 23:37:32 CST