Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance
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 - 11:53:45 CDT