Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
amun4
Starting Member
2 Posts |
Posted - 2013-10-29 : 03:25:42
|
I just change an application from Firebird database to mssql 2008.Generally mssql ist faster than Firebird.But i have problems with some transact codes.I have a table with 100000 records and 100 fields.Here my problem :update B_BT set BT_THM_AV=0 Firebird needs 2 secondsMS SQL needs 67 secondsWhy?Do I have to change the instruction of the codeline? |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-29 : 03:36:02
|
does table have any indexes?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
amun4
Starting Member
2 Posts |
Posted - 2013-10-29 : 03:58:16
|
Yes. the table has many indexes |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-29 : 05:14:41
|
too many indexes can also be a problem when doing DML operationsSee execution plan and check what are the costly steps------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|