PDA

View Full Version : Does too many tables slow down websites


mike_tw
04-19-2007, 11:39 PM
Just wondering if having too many tables in one database slows down a website and would it be better to have seperate databases rather than one big one?

Thanks:)

guelphdad
04-20-2007, 02:22 AM
if you are managing one website then you should have one database. even if you are managing multiple websites you can use the same database.

your question shouldn't be is there too many tables, it should be whether or not your database is properly normalized. if you are not familiar with database normalization, you should do a web search and read about it.