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 |
|
bigorno
Starting Member
2 Posts |
 Posted - 2002-06-27 : 08:33:14
|
| In a web-based message board application, many posters at a timewill add messages to the messages tree. Since adding an item intoa nested-set-based tree potentially means modifying left/right fora good deal of items, shoudn't the entire tree (table) be lockedduring the insert? In comparison, it seems that the "lineage"version does not require such a lock.Locking has never been mentionned in the discussion. Did I misssomething, or is it really an important point?Stephen |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-07-01 : 19:59:44
|
| check your other post for an answer...--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
|
|
|
Locking?