i am designing a website in php/mysql . well it is a social network. simple one. but i didnt know how to allow people to add friends . so i found the easiest way for me is to create a separate mysql table for each member containing all his/her friends.
but i am not sure if this will be fine.
couz lets say if my site got about 1000 new visiter per day. this will be 1000 new mysql table . is it realy going to be fine ??
if not. please tell me another way that can be better.
Jump to Post
Well data model isn’t something you decide through programming it should be set on a analysis base (if you are in a large scale project between demand department and analysis, programmer and feedback and if you are your own when you design the needs of your application before even write …
Jump to Post
for ease of sql queries and such I would make a table called friends with only 3 fields: id, friend1, friend2 (although you could name it more appropriately)
anyways for each and every user/friend store their id in friend1 and their friend's id in friend2. this means that each …
All 6 Replies
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.