From: "Farmer, Byrd G - CFC" <Farmer.Byrd@cfwy.com>
>
>I am having an issue with checkpoints taking an extremely long time during
>data loading. Normally during the day the checkpoints last 0 to 1 seconds,
>but when loading data, the checkpoint duration goes up to 30 to 80 seconds.
>Would increasing the physical log file help in this at all? I am using
>7.24
Checkpoints usually go up during loading. 30 to 80 seconds is not even the
longest time I have heard of. However, you have two basic strategies: use
LRU_MIN/MAX to get the writes taking place often and continuously, or set
them high (70/80), have long checkpoints, but possibly better overall
throughput.
Curved ball: have you considered getting your ETL tool to dump a flat file
and use HPL to load it?
>UC3 and using Informatica as my ETL tool.
Fie upon you! :-)
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com