anujgarg Posted October 20, 2008 Share Posted October 20, 2008 Hi I have some general queries, -- what points do we need to take care of during designing a database for a website? -- If we have two servers at two different locations, how can we relate these two to get the desired output? -- How can we speedup the loading of a web page ? Any technical (developer point of view) concept... Please suggest... TIA Link to comment https://forums.phpfreaks.com/topic/129259-points-during-database-designing/ Share on other sites More sharing options...
kenshintomoe225 Posted October 26, 2008 Share Posted October 26, 2008 Hi I have some general queries, -- what points do we need to take care of during designing a database for a website? Plan for expansion. Try to keep future changes to the structure of the database as cheap as possible by thinking of as many possible fields and tables early on, even if those tables end up empty or only have a few items in them. It's much more expensive to later go in and add columns and tables, and then relate them, after tons of data is already in place. Databases for a website will usually have some sort of 'user' table that is used as some sort of ACL, controlling what a certain user has access to. After that, it depends on what you want you site to do. -- If we have two servers at two different locations, how can we relate these two to get the desired output? I would designate one server as your database server, one as your web and application server, and have the web/app server connect to the database server. -- How can we speedup the loading of a web page ? Any technical (developer point of view) concept... Please suggest... TIA There are a number of things you can do. Namely, the way you write code is going to have an effect here, also the design of the database can play a part, and even the queries you write for that database. You might want to study relational databases in depth a little if efficiency is a big thing for you, as its a topic that would quickly fill one of these threads!! hope this helps!! Link to comment https://forums.phpfreaks.com/topic/129259-points-during-database-designing/#findComment-674973 Share on other sites More sharing options...
corbin Posted October 26, 2008 Share Posted October 26, 2008 You have two servers at two different places for the same thing? Why? Link to comment https://forums.phpfreaks.com/topic/129259-points-during-database-designing/#findComment-675033 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.