Well, it takes time to just fetch and display all those 17k rows with 60
columns in each. I don't see any reason for a client application to
retrieve the whole dataset and work with it locally, but if your application
works this way, be prepared for very heavy network traffic and very bad
performance - as I said, it takes time (and a lot) to just send all data to
client and your experiment shows nothing about how quickly Oracle was
able to start sending you rows (which was "immediately" since you
requested trivial full table scan).
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Lucas" <Lucas_44_at_hotmail.com> wrote in message news:tm4f9.10209$_J3.414519_at_news0.telusplanet.net...
> Ok, I was a little vague.
> Win2000
> P3 900 mhz
> 384 RAM
> Oracle 8 , testing on local machine only, not even on server with concurent
> users.
>
> I'm trying to optimize our db, I'm testing our SQL calls and seeing if
> indexing would help speed up the program. We can retreive records from
> different
> levels in the program, the higher the level the more records. I tried a
> straight call (select * from table), it has 60 fields, 17,000 recs and it
> took close to 1 min
> to get all the rows. This is from SQL*Plus, so obviously in a program with
> user interface, getting all the record plus all the lookups makes it ever
> slower. The fields
> are basic varchars, integers, couple of varchar2(255), 1 longraw with hardly
> any images in it.
>
> Lucas
>
>
>
>
> "Michael J. Moore" <hicamel_x_the_spam_at_attbi.com> wrote in message
> news:u04f9.259894$aA.44922_at_sccrnsc02...
> > With the small amount of information you have given, I'd say that
generally
> > you are right, that's pretty darn slow.
> > But if you are running on Win95, with 500 concurrent users, and your
columns
> > are imbedded tables or clobs,
> > maybe that is totally reasonable. You really need to give a lot more
> > information for anybody to make the kind of assessment you are looking
for.
> >
> > "Lucas" <Lucas_44_at_hotmail.com> wrote in message
> > news:bV3f9.10197$_J3.409715_at_news0.telusplanet.net...
> > > With just a basic (select * from ATable ) that has 60 fields and 17,000
> > > records it takes close to 1 min to retrieve all the row, seems slow to
me?
> > > Or am I expecting too much?
> > >
> > > Lucas
> > >
> > >
> >
> >
>
>
Received on Mon Sep 09 2002 - 12:15:37 CDT
