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 Quote Link to comment 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. Quote Link to comment 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? Quote Link to comment 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. Quote Link to comment 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! Quote Link to comment 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.