Feedback
Did this article resolve your question/issue?

   

Article

Performance optimization extending the bi file on Linux and Windows

« Go Back

Information

 
TitlePerformance optimization extending the bi file on Linux and Windows
URL NamePerformance-optimization-when-extending-the-bi-file-and-bigrow
Article Number000134059
EnvironmentProduct: OpenEdge
Version: 11.7.6, 12.1 and later
OS: All supported platforms
Question/Problem Description
Starting a database after a truncate bi is time consuming in a production environment with large bicluster sizes.
The time pre-growing the bi file with BIGROW delays startup times
Using bigrow to preformat large bi clusters varies on some platforms but not as much on others
Since 11.3 it takes longer to bigrow on Linux and Windows than AIX and Solaris environments 
Steps to Reproduce
Clarifying Information
Error Message
Defect/Enhancement NumberEnhancement OCTA-13489
Cause
Resolution
A performance improvement for adding new clusters to the bi chain was initially enhanced in OpenEdge 11.3 only for Solaris and AIX platforms. Windows and Linux environments still extend files unbuffered.

In OpenEdge 11.7.6 (when available) and 11.2.1, the performance mechanism used to extend the bi file was made available on all platforms including Linux and Windows. All supported platforms were enhanced to extend bi files using buffered I/O which improves:
  • The time to pre-grow the bi file before opening the database
  • The performance of extending the bi file during runtime, when clusters are added to the bi chain at a Checkpoint
For further details on the bi file cluster performance improvements which now apply to all supported platforms refer to Article:

 
Workaround
Notes
Last Modified Date11/20/2020 6:57 AM
Attachment 
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.