Posted by frizzle on 01/03/06 16:29

Hi there,

I'm going to build a simple forum in mySQL.
I've thought about it for a while now, but still can't figure it
out completely:

If i have say 5 main categories,
One has 5 sub-categories.
Each sub category consists of individual threads.
Wich each has the possibility to be commented.

The question concerns the thread & comments part.
My first idea was to create one table Threads, and one
Comments.
The Threads-table would have the original post, starting a thread,
and the Comments table would have the comment, and the id of
the thread it belongs to. (so all comments there are in the whole
forum)

Now i thought of the following:
I could create a new table for each thread to save it's comments in.
And call it e.g. 'Comments_4576', (belonging to thread 4576)

Pro is a lot faster to load, delete etc. but contra is more difficult
to
count cross-tables and everything.

What could i do best?

Greetings.

[Back to original message]