How to design the user table for an online dating site?

A

alien90

New Member
I'm working on the next version of a local online dating site, PHP & MySQL based and I want to do things right. The user table is quite massive and is expected to grow even more with the new version as there will be a lot of money spent on promotion.The current version which I guess is 7-8 years old was done probably by someone not very knowledgeable in PHP and MySQL so I have to start over from scratch.There community has currently 200k+ users and is expected to grow to 500k-1mil in the next one or two years. There are more than 100 attributes for each user's profile and I have to be able to search by at least 30-40 of them.As you can imagine I'm a little wary to make a table with 200k rows and 100 columns. My predecessor split the user table in two ... one with the most used and searched columns and one with the rest (and bulk) of the columns. But this lead to big synchronization problems between the two tables.So, what do you think it's the best way to go about it?
 
J

jamsaugustine

New Member
There are many people who are interested in designing and also there are many institutes where people can learn about website designing.Today there are many businesses that can be done at online so all of them must have their own websites.
 
R

rosicky

New Member
There are many people who are interested in designing and also there are many institutes where people can learn about website designing.
 
You must log in or register to reply here.
Top