How to control hashed file to arrange time
Posted: Wed Jul 18, 2001 4:04 am
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)
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)