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.