Salesforce

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 NumberOCTA-13489
Enhancement Number
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
Keyword Phrase
Last Modified Date2/2/2023 4:56 PM

Powered by