I am writting a webmail client using mysql as the backend. I wrote the
scripts using a table for each separate user. I am thinkig about putting
all users in one table. the table structure now is
pk, msg, folder. i am thinking about adding a separate field called user
are there any advantages or disadvanges for doing this.
I think some disadvantages could be larger/file table size and need of
locking tables for updates, and probably less security.
the advantages would be to have all the data in one table, and no need to
setup a table for each user.
i am new to my sql i aprreciate some feedback. this is the link for
the demo of the webmail. username demo password password. i am planning on
adding and address book, and bcc and cc fields for new messages. Right now
i get the address from a search feature but most email clients have
addressbook, so i figured i should add one too.
www.wittyadmin.com/demo.html