Re: LONG ROW performence problems

From: <michael_bialik_at_my-deja.com>
Date: Wed, 15 Sep 1999 21:07:38 GMT
Message-ID: <7rp1qi$21u$1@nnrp1.deja.com>

Hi.

What is your db_block_size ?
Try to create a db with block size of 16K, otherwise you will get row chaining.

Michael.

In article <37dfbc75.27833822_at_88.0.3.103>, tzifa_at_yahoo.com (Hope) wrote:
> 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
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 15 1999 - 16:07:38 CDT