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. 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 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 Link to comment https://forums.phpfreaks.com/topic/35651-big-database-design/#findComment-168936 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.