Re: 180 columns data retrieval

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 2000/07/23
Message-ID: <964387798.21950.0.nnrp-09.9e984b29@news.demon.co.uk>#1/1

What is the average row length ?

You may find that the client/server link is running with much smaller session data unit (sql*net SDU=nnn) than the server/server link so that each row takes 3 packets to arrive.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

parkstate_at_my-deja.com wrote in message <8l7f73$b3$1_at_nnrp1.deja.com>...


>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 Sun Jul 23 2000 - 00:00:00 CDT