acu4gl performance issue


Has anyone else experienced a performance issue when using MSSQL?   We are evaluating the Acu4GL product for MSSQL and we wrote a simple program that will write and read records using either Vision files or a MSSQL database.  

When doing a 40,000 record test, where the records are written to the filesystem, then read and then re-written; the total time to do these operations using the Vision file system is 4.41 seconds, doing the same operations to the MSQL database took 4 minutes and 44.35 seconds.   

I have tried using a few of the optimization suggestions in other posts, but the improvement is minimal.  I have attached a copy of the source we used for the test 

Any help would be appreciated.

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.