Posted on 2006-04-09
hi, i have a update process in my program that will update an average of 48k rows of data, but it only update 2-4 rows every single minute and it is breaking my balls.
i created the index, clustered, non-clustered, it all the same.
i have test run the same process, table structure, indexes on MySQL and it only need about 10mins! whereas the SQL Server takes several hours! just for 48k rows?!
I'm sure MS SQL Server can do better than take, just that I might miss up sth (configuration on the buffer size or watsoever).
besides, my update involve updating date fields, can this causes problem?
i have set the auto-commit to false, and uses batch update that execute every 1000 rows of data then commit.
I am totally new to MS SQL Server, so please help...