Hi, I've developed a database access module of a medium-size application using APO .NET on SQL Server 2000 Developer's edition under windows 2000. The desktop I'm using has P4 2.0GHz CPU and 512M memory. Now I'm doing testing on Sql Server 2000 Enterprize Edition under Windows Server 2003 Stardard edition. The server machine has 4 P4 3.06GHz CPU and 1G memory. Howevery, I founnd that insertion to the database is even slower than on my desktop! Say, insertion of 1000 records to the Sql Server on my desktop takes around 1860 ms, but 7280 ms on the server machine! Can anybody advise me what would be the possible cause of this unreasonable behaviour. Thanks a lot!
