daydreamer Posted September 1, 2008 Share Posted September 1, 2008 I am building a website which deals with sending messages. At the moment my database has a table which stores these messages: ID(pk), member_id, number, message, date. On one of the pages my site allows the users to see the messages they have sent, and also delete them. When they are deleted, I want to keep them in the database, but not show them on the users 'message page'. Which way would be faster/best? To have a table identical to the one above, but when the user deletes them, just delete them from one table. Or put in another column, "deleted", 0=show message, and 1=do not show message. Link to comment https://forums.phpfreaks.com/topic/122296-php-and-mysql-performance-question/ Share on other sites More sharing options...
DarkWater Posted September 1, 2008 Share Posted September 1, 2008 I'd make a deleted column. Link to comment https://forums.phpfreaks.com/topic/122296-php-and-mysql-performance-question/#findComment-631513 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.