How to control hashed file to arrange time

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

How to control hashed file to arrange time

Post by admin »

Hi,

I wanna write large volumn data to hashed file for lookup (average length 76bytes, rocord count 24million record(24000000),

But I get the problem, so many times need to arrange hashed file.

when I load data to hashed file, arrange data by every 800000 record processing,

without arranging data, performans is 3000 rec/sec, but avarage performance is lower than 1000 rec/sec.

I want to why to arrange (I guess) loaded data by every 800000 rec. and If possible, How to change configuration to arrange interval .

Ill thank for any tip.


Regards
Daehwan Kim (whatcanido@lexken.co.kr 82-2-3453-0320 ext 303 )

S.E Team
Data Solution Division
Lexken (www.lexken.co.kr)
Locked