programming.name Posted May 12, 2010 Share Posted May 12, 2010 Hi, As a database designer or DBA, how do you design the database for a site where there are lots of people and a single user writes a lot of threads? For a small sized site, I think it is possible to create only one table to store users' info and other info. But as the site get bigger, I think a single table may be used for a single user since there are lots of info like PHP's threads and MySQL's thread, ect to store. If I am wrong would you explain how to design the database please? Thanks! Link to comment https://forums.phpfreaks.com/topic/201510-question-about-how-to-design-databases-for-larger-site-for-users/ Share on other sites More sharing options...
ignace Posted May 12, 2010 Share Posted May 12, 2010 how do you design the database for a site where there are lots of people and a single user writes a lot of threads? What do you mean by writes a lot of threads? You can use: CREATE TEMPORARY TABLE table_name SELECT * FROM table_name For each user and allow only an admin access to the actual table_name (UPDATE, INSERT, DELETE) Link to comment https://forums.phpfreaks.com/topic/201510-question-about-how-to-design-databases-for-larger-site-for-users/#findComment-1057230 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.