|
> -----Original Message----- > From: Graap, Ken [mailto:keg@nwnatural.com] > Sent: Sunday, August 19, 2001 8:42 PM > To: 'midrange-l@midrange.com' > Cc: 'sublime78ska@yahoo.com' > Subject: RE: sql exec speed. was AS/400 STILL wearing the undeserved > "closed system" moniker > > > >To write 100,000 records without journaling was about 2 minutes. > >To write 100,000 records with journaling was about 24 minutes. > > Phil - > > How was journaling configured? The journals were created when CREATE COLLECTION was executed. > > Were the receivers in a separate ASP? No > > How many disk arms were allocated to the receiver ASP? > > Were the disks Mirrored or RAID'ed? RAID > > Was receiver option *MAXOPT1 used? Don't know. > > There are just a few of the things that affect how efficient > journaling can > be. > > Kenneth > -- > ******************************** > Kenneth E. Graap > IBM Certified Specialist > AS/400 Professional > System Administrator > NW Natural - Information Services > System Services > Phone 503 226 4211 X5537 > FAX 603 849 0591 > keg@nwnatural.com > ******************************** > > > > > -----Original Message----- > From: Phil [mailto:sublime78ska@yahoo.com] > Sent: Sunday, August 19, 2001 5:27 PM > To: midrange-l@midrange.com > Subject: RE: sql exec speed. was AS/400 STILL wearing the undeserved > "closed system" moniker > _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.