Re: dbload - performance

In article <3sq18b$ou@cssun.mathcs.emory.edu> jparker@hpbs3645.boi.hp.com "Jack Parker" writes: <big snip> > My question is therefore - does anyone have thoughts on optimizing dbload <snip> i) In SE turn of the logging first by updating the 'syslog' row in systables (so tabtype != 'L') and then run 'dbload'. I don't know if there is an OL equivalent to this. ii) In SE & OL drop the indexes (if any), load the data & recreate the indexes. iii) In SE & OL ensure that the file being loaded is on a different device to the table being loaded into, otherwise the heads can fly many miles, inches, centimetres or whatever in the process. Regards -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================