anon Posted June 27, 2007 Share Posted June 27, 2007 I was woondering if the following is a good structure for a database for my site. A big DB, containing topics for the posts, these topics each have their own, Smaller databases containing sub-topics. If i were to create my own site search, would this method be good for searching and indexing, as in would it speed things up a bit? Thanks Link to comment https://forums.phpfreaks.com/topic/57410-solved-is-this-a-good-structure-for-a-database/ Share on other sites More sharing options...
trq Posted June 27, 2007 Share Posted June 27, 2007 Searching accross mutliple databases would be a nightmare. Are you sure you have the terminoligy correct? Do you meen tables? Even then, topics do not need there own table. Look into database normalization techniques. Link to comment https://forums.phpfreaks.com/topic/57410-solved-is-this-a-good-structure-for-a-database/#findComment-284064 Share on other sites More sharing options...
anon Posted July 3, 2007 Author Share Posted July 3, 2007 So what you are saying is that there is one big database, and inside there are tables, containing different info? I heard that google have lots of different db's spread over their many different servers, and they are the kings of search. PS: How does google spread it over many db's? Link to comment https://forums.phpfreaks.com/topic/57410-solved-is-this-a-good-structure-for-a-database/#findComment-288657 Share on other sites More sharing options...
roopurt18 Posted July 3, 2007 Share Posted July 3, 2007 When you have content getting slammed by millions of people every day expecting millisecond response times, then you can start thinking about spreading DBs across multiple servers. Link to comment https://forums.phpfreaks.com/topic/57410-solved-is-this-a-good-structure-for-a-database/#findComment-288830 Share on other sites More sharing options...
anon Posted July 4, 2007 Author Share Posted July 4, 2007 OKAY! You got a good point there. Thanks! Link to comment https://forums.phpfreaks.com/topic/57410-solved-is-this-a-good-structure-for-a-database/#findComment-289786 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.