LONG ROW performence problems

From: Hope <tzifa_at_yahoo.com>
Date: Wed, 15 Sep 1999 15:46:27 GMT
Message-ID: <37dfbc75.27833822@88.0.3.103>

Hi All

I have this problem
I need to store a file containing a key and a variable length record in a table
The record length can get up to 32K but the avarage is 8-12K

My current definition is:
KEY1 RAW(12) NOT NULL,
FLD1 LONG RAW
I'm fetching the LONG RAW data using oflng()

The problem is that my users complain it's too slow

The solution I'm considering now is to define a row like this:

KEY1 RAW(12),
FLD1 RAW(2000),
FLD2 RAW(2000),

. . . .
FLD16 RAW(2000)
and fill the unused raw fields with NULL

This solution assures the fields are all stored together with trhe table unlike the LONG RAW which may be stored elsewhere.

Is there a better or simpler solution?

Shaya Received on Wed Sep 15 1999 - 10:46:27 CDT