I'm curious, which generated more loading time and/or costs more space in a (my)sql database ?
a single table with a collum called category, which can be used to filter out content in a query such as this:
"SELECT * FROM content WHERE category = 'foo' "
or seperate tables, such as: bleat, foo, and squibble, where the query is
"SELECT * FROM foo"
i'm curious, which method is best, and why.
-edit: well people, i already had some ideas on what was more practical: and now i'm absofuckinglutely convinced. All that shit is going into the same table.
Thanks heeps, peeps'
a single table with a collum called category, which can be used to filter out content in a query such as this:
"SELECT * FROM content WHERE category = 'foo' "
or seperate tables, such as: bleat, foo, and squibble, where the query is
"SELECT * FROM foo"
i'm curious, which method is best, and why.
-edit: well people, i already had some ideas on what was more practical: and now i'm absofuckinglutely convinced. All that shit is going into the same table.
Thanks heeps, peeps'
