From: "Michael J. Moore" Newsgroups: comp.databases.oracle.server References: Subject: Re: Performance Lines: 18 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: NNTP-Posting-Host: 12.234.158.148 X-Complaints-To: abuse@attbi.com X-Trace: sccrnsc02 1031589018 12.234.158.148 (Mon, 09 Sep 2002 16:30:18 GMT) NNTP-Posting-Date: Mon, 09 Sep 2002 16:30:18 GMT Organization: AT&T Broadband Date: Mon, 09 Sep 2002 16:30:19 GMT 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 > >