Hi,

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.