performance problem

[eluser]Michael Wales[/eluser]
Despite the obvious disorganization benefits you will only have a problem in terms of "finding content." I'm assuming you return this content via an id field or a slug - either way, you need to have these fields indexed.

The problem will come in when you have 300 blog posts and 20,000 comments. Let's say your front page features the 10 most recent posts - you are forcing the database to look through 20,300 rows to find the 10 you want, rather than just searching through 300 rows.

Good indexing will reduce the time it takes to find the rows you want but it really should be tackled with individual tables.