Re: Loading speed

From: Thomas Stainer <tstainer@styria.com> > >Running IDS 7.30 UC6 on a 4CPU HP9000 (HP-UX 10.20), we have every now >and then to load larger tables (some 2 - 5 million rows) and create some >indexes on them. Before doing this we turn the logging mode from >unbuffered to no logging, we increase checkpoint intervals but >nevertheless load takes a very long time. >Does IDS 7.* already has the High Perfomance Loader (I guess no)? >How can I speed up the loading process? > >thanx for every useful advice I won't be getting any thanks, then. Firstly, I believe HPL is available for 7.30, but you may actually want to read your release notes to confirm that. Secondly, drop your indexes before the load and then rebuild them afterwards. Check out PSORT_NPROCS, PSORT_DBTEMP and PDQPRIORITY for improving index build performance. Thirdly, the next best advice I can give for improving performance is to FRAGMENT the loading table BY ROUND ROBIN across multiple spindles. Finally, you may get better performance by splitting your load into multiple files and loading them in parallel. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com