Best storage model for forum application?
Trying to build application which will be a forum, with topics and every topic may have many discussion posts to it, and every discussion post may have reply to it. So it'll be like:

    [Topic: Let's talk about cell phones]
    \
     \
      \ [User A: I have nice Motorola]
      | [User B: I have good Blackberry]
         \ [Reply to User B from User C: I prefer iPhone to Blackberry!]
         \ [Reply to user B from User X: I like Blackberry, too!]
      | [User D: Something else]

 
Something like that.

The problem is that I need to be prepare for large volumes of comments. Also, need performance is important, and I need to be able to check all replies to discussion post, as well as all comments and comments "around it" by date/time within the topic.

Should I use SQL? Or some key-value storage? Who had experience with them? Any ideas on structure to build?

Thanks.
Best storage model for forum application?
===

Trying to build application which will be a forum, with topics and every topic may have many discussion posts to it, and every discussion post may have reply to it. So it'll be like:

    [Topic: Let's talk about cell phones]
    \
     \
      \ [User A: I have nice Motorola]
      | [User B: I have good Blackberry]
         \ [Reply to User B from User C: I prefer iPhone to Blackberry!]
         \ [Reply to user B from User X: I like Blackberry, too!]
      | [User D: Something else]

 
Something like that.

The problem is that I need to be prepare for large volumes of comments. Also, need performance is important, and I need to be able to check all replies to discussion post, as well as all comments and comments "around it" by date/time within the topic.

Should I use SQL? Or some key-value storage? Who had experience with them? Any ideas on structure to build?

Thanks.