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 |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2007-10-05 : 09:01:38
|
| Is it normal that delete all rows in a table of 1.5 million rows takes 10 minutes?Do you find that normal and acceptable or does that mean there is something wrong in our server?Thanks. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-05 : 11:25:29
|
| "Is it normal that delete all rows in a table of 1.5 million rows takes 10 minutes?"Probably, yes."Do you find that normal and acceptable or does that mean there is something wrong in our server?"To me it means that you should program this differently not to put an ATOMIC transaction on a delete that is so large. |
 |
|
|
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2007-10-05 : 11:34:26
|
| Thanks. |
|
|
|
|
|
|
delete from myTable takes 10 minutes