From: "Lucas" Newsgroups: comp.databases.oracle.server References: Subject: Re: Performance Lines: 50 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Message-ID: Date: Mon, 09 Sep 2002 16:53:45 GMT NNTP-Posting-Host: 207.34.105.11 X-Trace: news0.telusplanet.net 1031590425 207.34.105.11 (Mon, 09 Sep 2002 10:53:45 MDT) NNTP-Posting-Date: Mon, 09 Sep 2002 10:53:45 MDT 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" wrote in message news:u04f9.259894$aA.44922@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" wrote in message > news:bV3f9.10197$_J3.409715@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 > > > > > >