ee-itpro
asked on
ADVICE NEEDED FROM PROEVEN DATABASE AND HIGH TRAFFIC SITE EXPERTS ONLY !
PLEASE DO NOT ANSWER THIS QUESTION UNLESS YOU ARE A PROVEN DATABASE (MYSQL) EXPERT AND HAVE SOME EXPERIENCE WITH MODERATE TO HIGH TRAFFIC SITE.
Hi,
First of all thanks for bearing with me. Since i do not want just about anyone answering this question and then seeing the question being ignored since it's already been answered(even though the advice may not be relevant or qualified enough) i put the above notice.
Apologies if it sounds rude to anyone.
However, I appreciate advice through multiple answers/experts and probably would allocate hundred times more points if it was in my hands.
Getting to the point,
I have a database design/schema for a classifieds/listings site. This is currently done in MyISAM engine so there are no relationships, keys etc.
I need to know if i'm on the right track with the DB Design... (The Email and Password fields are redundant in both Users and Ads tables since the first plan was not to require user registration but that plan was changed lately. So, please ignore this bit since i'll remove these fields from Ads table)
It's expected that the site has the potential to do at least a minimum of 100,000 page views a day within a few months from launch.
Please advice about what do you think about this design and what could be done better.
I'm posting below the links to the images of ER diagrams for the current design.
http://i1192.photobucket.com/albums/aa322/techpics2011/er1.jpg
http://i1192.photobucket.com/albums/aa322/techpics2011/er2.jpg
Also please advice on the best Db Engine to use for such a site(InnoDb or any other...). I am posting a separate question for this. Here's the url to the question :
https://www.experts-exchange.com/questions/27290666/what's-the-best-MySql-Engine-for-my-database.html
Hi,
First of all thanks for bearing with me. Since i do not want just about anyone answering this question and then seeing the question being ignored since it's already been answered(even though the advice may not be relevant or qualified enough) i put the above notice.
Apologies if it sounds rude to anyone.
However, I appreciate advice through multiple answers/experts and probably would allocate hundred times more points if it was in my hands.
Getting to the point,
I have a database design/schema for a classifieds/listings site. This is currently done in MyISAM engine so there are no relationships, keys etc.
I need to know if i'm on the right track with the DB Design... (The Email and Password fields are redundant in both Users and Ads tables since the first plan was not to require user registration but that plan was changed lately. So, please ignore this bit since i'll remove these fields from Ads table)
It's expected that the site has the potential to do at least a minimum of 100,000 page views a day within a few months from launch.
Please advice about what do you think about this design and what could be done better.
I'm posting below the links to the images of ER diagrams for the current design.
http://i1192.photobucket.com/albums/aa322/techpics2011/er1.jpg
http://i1192.photobucket.com/albums/aa322/techpics2011/er2.jpg
Also please advice on the best Db Engine to use for such a site(InnoDb or any other...). I am posting a separate question for this. Here's the url to the question :
https://www.experts-exchange.com/questions/27290666/what's-the-best-MySql-Engine-for-my-database.html
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER