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 |
|
amsqlguy
Yak Posting Veteran
89 Posts |
 Posted - 2008-11-02 : 09:10:17
|
| Guys,I have table which is growing on daily basis currently there are 3mill rows in this table.I am trying to explore if it is worth archiving the records and at any point retain only records for one business day. In this process I have a question.In terms of insert DML performance what is the difference if A row is inserted in the same table which has 3 mill rows versus a row inserted in the same table with 1000 rows.Any inputs/suggestions will help.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
DML Insert Performance