Hello Magnus, MS> Is there one new MESSAGEBLK created in the database for each user for MS> these messages, or is the MESSAGEBLK shared between the users.
Yes, there is a complete message (1 entry into message and 2 or more into messageblk tables) for each recipient. Send a message to 1,000 people on the system, and 1,000 copies of it exist. The only system that does NOT do that, to my knowledge, is Exchange Server; it maintains a separate table internally to keep track of which users have seen/deleted the message, and doesn't actually delete it until ALL have seen it. While this is more space efficient, it is also a nightmare if certain users decide to move the message to one of their mailbox folders (maintained on the server, rather than on their local machine), because the copy makes a new link... message bodies can be cross linked endlessly, making problems if you ever need to restore the database. At least some backup procedures "fix" this by saving individual "snapshots" of the tables, so you end up with a backup containing a complete copy of these group messages for each user who hasn't purged it from their mailbox, and the restore ends up having multiple copies anyway... -- Jeff Brenton President, Engineered Software Products, Inc http://espi.com Questionable web page: http://dididahdahdidit.com Liberalism grants you the freedom to advocate any idea*. * Please see http://www.dididahdahdidit.com/except.php for a current list of exceptions
