×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
On 18 Jan 2013 07:00, Charles Wilt wrote:
Journaling without commitment control has a significant impact on
batch jobs doing writes...the more writes, the more impact.
About the only scenario where it would NOT have an impact is if all
the tables you're writing to have FRCRATIO(1) anyway...
Agreed about the impact of Force Ratio. IME the asynchronous writes
with wait sent to journal pages proved to be faster than synchronous
writes to the dataspace; i.e. a Force Ratio of one was much more costly
than using journaling. This was shown consistently [given a properly
configured system, with at least minimum disk\arms] to be the case when
the system database cross files were changed from originally using a
force ratio of one to ensure data integrity to later using journaling to
ensure data integrity. The difference in full rewrite of the data
[refresh the DBXREF] was consistently faster when journaling than when
using FrcRatio(1). The effect for delete and update were not formally
tested, but there were AFaIK no complaints.
Having a journal to replace the sync force feature enables reviewing
the I/O and as an added bonus also enables an application to have a
convenient "log" to record more than just the I/O; at the cost of the
additional storage, but even that over time has become much less of an
issue.
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.
midrange.com
