Re: Checkpoint duration

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