Re: INSERT performance problems

Thanks for the tip. Alas, the table is already fragmented across four high-speed RAID LUNs. No, the key to the performance problem seems to be the number of constraints and indexes that live on the table. If I insert the records with these enabled, it takes about 14 minutes per hundred thousand. With them disabled, it takes about two to three minutes to insert the same number of records. Unfortunately, when I re-enable the disabled constraints, it takes an hour, so disabling them doesn't buy me much. RG <rag4@mead.com> wrote in message news:3706DF65.28C2@mead.com... > You may need to look into fragmentation. Add some high speed drives and > drive controllers and fragment the table across them. Fragmentation is > pretty high maintenance, but ya gotta do whatcha gotta do. > > Robert > > BEATRIZ ROCHA wrote: > > > Even better, you could try to drop the indexes and constraints, then use > > HPL to load the data and then re-create the indexes > > and constraints. > > > The problem is that I've got a huge accounts receivable table (1.6 > > million > > > rows), into which I need to be able to do large inserts (hundreds of > > > thousands of rows) for our end-of-period posting. These inserts take > > > several hours to complete. My window is more like two hours. > > > >