[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?
