Mssql design question !!!

Discussion in 'Databases' started by greekhand, Sep 25, 2007.

  1. #1
    Hi , i have a website write with asp.net .

    i didn't found any built-in forum application , like phpBB for php .

    i may try to do that myself ...

    and i got a quiestion :
    to make table of post for every forum ?? or to make 1 table of posts for all the forums .

    Thanks .
     
    greekhand, Sep 25, 2007 IP
  2. it career

    it career Notable Member

    Messages:
    3,562
    Likes Received:
    155
    Best Answers:
    0
    Trophy Points:
    270
    #2
    first option would be better.
     
    it career, Sep 25, 2007 IP
  3. kjewat

    kjewat Active Member

    Messages:
    149
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    53
    #3
    Why do you think it would be better ? A statement is not much worth if you don't explain why...

    I don't see any reason for that. I would rather have one table for all the posts and a foreign key to a forums table.

    Let's say that you want to search for some post across all forums. That would be quite a hassle if you have one table of post for each forum....
     
    kjewat, Sep 25, 2007 IP
  4. greekhand

    greekhand Active Member

    Messages:
    249
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    53
    #4
    ok , good ideas

    Thanks alot guys .
     
    greekhand, Sep 25, 2007 IP
  5. bluegrass special

    bluegrass special Peon

    Messages:
    790
    Likes Received:
    50
    Best Answers:
    0
    Trophy Points:
    0
    #5
    If you are referring to all of the sub-forum posts of a single top-level forum being in one table or multiple, then I would agree with kjewat. It will make other features of the forum easier to write (like find all posts by a given user, or searching by keywords).

    If youy are referring to having multiple top-level forums (like dp, webmasterworld, etc...) then each should have its own table to reduce table size.
     
    bluegrass special, Sep 25, 2007 IP
  6. dp_net

    dp_net Guest

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Hi,

    use masterpages concept in asp.net to create table of post and use it for all the forms in ur application.
     
    dp_net, Sep 27, 2007 IP
  7. kjewat

    kjewat Active Member

    Messages:
    149
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    53
    #7
    kjewat, Sep 27, 2007 IP
  8. dman_2007

    dman_2007 Peon

    Messages:
    1,259
    Likes Received:
    62
    Best Answers:
    0
    Trophy Points:
    0
    #8
    dman_2007, Sep 27, 2007 IP