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)


Comments

Popular posts from this blog

java - Plugin org.apache.maven.plugins:maven-install-plugin:2.4 or one of its dependencies could not be resolved -

Round ImageView Android -

How can I utilize Yahoo Weather API in android -