leosurf91 — 2010-02-18T15:28:41-05:00 — #1
I've set up a few PM systems in the past and I always make it so each user has their own message table. This allows them to perform edits (such as deletion) on their messages. However this seems like it could be a problem if there are alot of users. What mysql configuration would I need, or is there a better solution just using just a few tables to handle all of the users messages.
r937 — 2010-02-19T22:44:29-05:00 — #2
put all the messages into a single table, and make sure it's innodb, so that inserts and deletes will not lock the entire table