Re: Performance of Multiple Inserts
From: Saad Ahmad <sahmad_at_mfa.com>
Date: 1995/08/10
Message-ID: <40dbhi$fnp_at_homer.alpha.net>#1/1
Date: 1995/08/10
Message-ID: <40dbhi$fnp_at_homer.alpha.net>#1/1
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.
-- ************************************************************** * Saad Ahmad * * McHugh Freeman & Associates, Inc. * * Ph: (414) 798-8606 Ext. 457 * * Fax: (414) 798-8619 * * E-Mail: sahmad_at_mfa.com * **************************************************************Received on Thu Aug 10 1995 - 00:00:00 CEST