180 columns data retrieval

From: <parkstate_at_my-deja.com>
Date: 2000/07/20
Message-ID: <8l7f73$b3$1@nnrp1.deja.com>#1/1

Version of Oracle 8.1.5
OS: Compaq Unix 4.0E

Trying to access a table with about 180 columns from a Pro*C program - actually, even a simple 'select * from test' statement can be used in this example as this is what is finally constructed. It takes thrice the amount of time to perform this task from any client as compared to the time it takes to run directly on the server.

The table is 3M in size with about 1000 rows.

Any Suggestions? Any SQL Net hints?

Thanks

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jul 20 2000 - 00:00:00 CDT