I wanted to know an efficient schema for a receiving comments
My website is having a taste of Social Networking.I wanted an efficient database schema for comment filled.
Currently i am generating row for every comment per user per Message in the table named tbl_comment but the table is getting very big.
Can any one suggest me some useful schema for comments.
Suggesting on managing frndlist,frndrequest etc is also appreciated.
Thanks !!!
I wanted to know an efficient schema for a receiving comments
===

My website is having a taste of Social Networking.I wanted an efficient database schema for comment filled.
Currently i am generating row for every comment per user per Message in the table named tbl_comment but the table is getting very big.
Can any one suggest me some useful schema for comments.
Suggesting on managing frndlist,frndrequest etc is also appreciated.
Thanks !!!