danger2oo6 Posted January 25, 2007 Share Posted January 25, 2007 Hi all,I need a little help in a database design.I want to design a database which will have around 500.000 records and I would like to know if you know some rules I have to follow.The database will be used for a dating site where will be lots of query`s on the database and a good database design will improve the response time.Thank you in advance,Bogdan. Quote Link to comment https://forums.phpfreaks.com/topic/35651-big-database-design/ Share on other sites More sharing options...
shoz Posted January 25, 2007 Share Posted January 25, 2007 http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html Quote Link to comment https://forums.phpfreaks.com/topic/35651-big-database-design/#findComment-168930 Share on other sites More sharing options...
cmgmyr Posted January 25, 2007 Share Posted January 25, 2007 The best things to start with is to use id's for everything and don't duplicate data. For example when you put in your messaging service on your site, don't use username_to or username_from, use id_to and id_from. So instead of:To: danger2oo6 From: cmgmyrit would be:To: 23From: 64...or whatever numbers they are. Then you query the member name and whatever else you need. By making your database this way it will cut down a lot of space and your queries will be faster.-Chris Quote Link to comment https://forums.phpfreaks.com/topic/35651-big-database-design/#findComment-168936 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.