SQLServer 2008 on Win64 20x slower than on Win32

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 99
Joined: Sat 18 Aug 2012 08:33

SQLServer 2008 on Win64 20x slower than on Win32

Post by LHSoft » Sat 24 Aug 2013 09:19


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

It seems that only TMSTable.insert or append is causing this performance issue.

Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: SQLServer 2008 on Win64 20x slower than on Win32

Post by AlexP » Tue 27 Aug 2013 12:08


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.

Post Reply