REPOST: Archive Log Affect Performance?: UPDATE

From: Noodles <noodles_at_aol.com>
Date: 26 Jan 2002 01:27:25 GMT
Message-ID: <8$--$%%%%--$%__-$$@news.noc.cabal.int>

FYI Today I ran the test to figure out whether archive logging on a large update affects performance. This question caused a minor flurry of posts last week. Results are below:

environment: HP K580 , Unix 11, ORA 8.1.7 test set = 230000 records

Arch logging		Time
Yes			952 seconds
No				958 seconds

I don't believe the 6 seconds is significant when consider the background noise (other processes) on the machine. This test machine had 13 other instances.

I guess I need a larger dataset to increase the precision.

Cliff

WAS CANCELLED BY =======: From: noodles_at_aol.com (Noodles) Control: cancel <20020125202725.10434.00000434_at_mb-ct.aol.com> Subject: cmsg cancel <20020125202725.10434.00000434_at_mb-ct.aol.com> Date: Mon, 28 Jan 2002 01:25:26 GMT X-Admin: news_at_aol.com Organization: AOL http://www.aol.com Message-ID: <cancel.20020125202725.10434.00000434_at_mb-ct.aol.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!news.fh-hannover.de!news-han1.dfn.de!news-ham1.dfn.de!news-ber1.dfn.de!news-fra1.dfn.de!news-lei1.dfn.de!newsfeed00.sul.t-online.de!t-online.de!colt.net!newsfeed.esat.net!nntp.cifnet.net!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40721400

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 19:27:25 CST