php - Managing 1000+ user and each user's having 20,000+ rows for storing data in mysql -
i using php , mysql create website. accepting @ least 1000 users. each user have 10000+ objects(different user may have different objects) , each object have @ least 5 properties.so if create table object_id | object_name | object_user_id | property_1|property_2|...|property_5 then have 10 million rows. solution not acceptable. shall create table each user? thanks in advance... according given description in question may need 3 tables. 1. user --> userid , username , etc... 2. object --> objectid , objectname , etc... , userid (reference of user ) 3. property --> propertyid , propertyname , etc... , objectid (reference of object )