Re: Performance of Multiple Inserts

Saad Ahmad (sahmad_at_mfa.com) wrote:
> David Roberts (droberts_at_seas.gwu.edu) wrote:
 

> > 1. I suspected that the program might run faster if it committed about a
> > whole pageful of data and then COMMITted, rather than issuing a COMMIT
> > after each INSERT. What do you think?
> Yup. You should have big rollback segments though. Also have more
> rollback segments on multiple tablespaces.
>

   Also drop any indexes, constraints on the table. Then rebuild them

--
**************************************************************
*                          Saad Ahmad                        *
*                          McHugh Freeman & Associates, Inc. *
*                          Ph:  (414) 798-8606 Ext. 457      *
*                          Fax: (414) 798-8619               *
*                          E-Mail: sahmad_at_mfa.com            *
**************************************************************