SQL Server 2005 Express Very Slow

Hi,



I have got an application running which connects 2 databases and performs an action that copies data from one database to the other database.

When using SQL Server 2000 MSDE, it takes about 5 seconds.

When using SQL Server 2005 Express Edition it takes about 30 seconds.



For testing 2005, I use 'upgraded' databases, so same indexes and data. I tried reindexing the databases, but always get the same result.



My setup string for installing SQL Server 2005 Express is :



/qb ADDLOCAL=ALL INSTANCENAME=DBNAME SECURITYMODE=SQL SAPWD=QWERTY SQLACCOUNT="NT AUTHORITYSYSTEM"



The code (ADO) is something like :



SELECT FROM original database

-- do something with data

INSERT INTO other database

Until EOF



Any idea how to solve this ???



P.S. When perfoming a simple Query on the databases (with 1.000.000 rows result) with SQL Server Management Studio Express, I see 37 seconds for SQL Server 2000 and 33 Second for SQL Server 2005. That is more the result I expect.

-------

XPPro SP2 3Ghz 1Gb