Hello,
i have been using sql Server Express 2008 32bit on win7 32bit with 4GB Ram on machine til now.
Now I am testing a new Computer with Win7 64bit and 16GB Ram and SQLServer Express 2008 64bit and 64bit Native Client. This new machine is much faster than my old one.
All settings should be the same, because I have automatic silent install-script for SQL server.
But on 64bit for example to insert 60.000 Datasets in a table lasts more than 20 times as long as on 32bit. My software still runs in 32bit mode.
I have tried to install 32bit SQLServer on Win64 with 32bit Native Client but the same results. I tried SQL Server Express 2012 too, but also the same slow results.
What can I do?
best regards
Hans
It seems that only TMSTable.insert or append is causing this performance issue.
SQLServer 2008 on Win64 20x slower than on Win32
Re: SQLServer 2008 on Win64 20x slower than on Win32
Hello,
The bitness of the server, client and OS doesn't affect the SDAC performance. Please try to conduct the similar performance tests on the standard ADO components, and let us know the results.
The bitness of the server, client and OS doesn't affect the SDAC performance. Please try to conduct the similar performance tests on the standard ADO components, and let us know the results.