Absent Member.
Absent Member.

[archive] acu4GL "Open" file speed issue

[Migrated content. Thread originally posted on 21 September 2010]

We are ISV, and we have reported an incident for support. This is the incident description,is there any company which has similar issue?

Our application is web based "cgi" program.
Now we use vision file system and acuCOBOL8.11.
We try to use acu4GL and MSSQL 2008R2 Express to replace the vision file system.
We find the "Open" file really expensive in time-consuming.
We use "SQL SERVER Profiler" to trace the "OPEN" operation.
We see two lines is the major time-consuming sections.

please see the attachments "screenshot1" and "screenshot2".
The first entry(screenshot1) we solved by adding missing procedure "sp_AcuInit".
But the second entry(screenshot2), we could NOT understand why it takes that long time(duration time = 529 milliseconds).

In the attachments, "openafile.bmp" shows the testing code only does an open operation and printing log file.
"logfile.bmp" shows you the output time duration by COBOL code.
and "wholetracelog.bmp" shows you the complete SQL SERVER Trace log.

Is there any way to improve the file open speed which is very important for our web applicaton response time?
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.