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! Quote 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) Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.