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 |
|
d17may
Starting Member
7 Posts |
 Posted - 2006-06-09 : 03:07:28
|
| I have table which has insertion rate of 1 rows /per min.There are hundreds of similar tables .I want to know whether to index this table (on datetime field).how much it affect the insertion performance.Thanks d17may |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-06-09 : 03:21:49
|
| Most often indexes slow down insertion, since SQL Server has to update and manage the index after each insert statement.But 1 ins/min? That is very slow. My old laptop handles up to 41,000 single-line ins/min. |
 |
|
|
d17may
Starting Member
7 Posts |
Posted - 2006-06-09 : 03:38:03
|
quote:
Originally posted by Peso
Most often indexes slow down insertion, since SQL Server has to update and manage the index after each insert statement.But 1 ins/min? That is very slow. My old laptop handles up to 41,000 ins/min.
If there is only one table then no problem .But sql server has to handle hundreds of similar tables .what is the effect on overall performanceThanks d17may |
|
|
|
anuj164
Starting Member
49 Posts |
Posted - 2006-06-09 : 12:28:53
|
| how big is your table |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-06-09 : 16:03:26
|
| How often do you select form those tables? Could you add the indexes at that point, or periodically dump the data to an "indexed" table?Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights. |
|
|
|
|
|
|
Index or not