performance with many columns

From: Bart News <bartb_at_allinson-ross.com>
Date: Thu, 6 Jan 2000 15:39:34 -0500
Message-ID: <v37d4.1053$S64.35011@nnrp1.uunet.ca>

I am having serious performance problems with Oracle when using batch programs (PRO*C or PRO*COBOL), that need to travers (read from top to bottom) fairly wide tables, i.e. tables with around 200 columns (table is about 1000 characters wide).

I have plenty memory(1 GB), a fast, 8 CPU, UW7 machine, RAID disk, but compared to reading the same file in C-ISAM mode, performance is more than 7 to 10 times slower. As far as I can tell, my system is configured well.

Using Oracle 8 too, which allows up to 1024 columns.

Any suggestions, pointers to papers ?

Bart Blom Received on Thu Jan 06 2000 - 14:39:34 CST