0

Hey guys,

What are your opinions on rating systems in this case? I have users submitting ideas. Now other users can rate an idea UP or DOWN. I want to keep track of what user rates what idea, up or down, and want to be able to display this information on a page of my site, ordering by highest rated ideas or lowest rated ideas.

Is this the best way to go about this?

[B]IDEAS Table[/B]
ideaID                    (auto increment prim key)
ideaText                   (actual paragraph of text detailing idea)
userID           (userid of user that submitted idea)
[B]RATINGS Table[/B]
ratingID       (auto increment prim key)
rateType       (single boolean, 0 for rate down, 1 for rate up)
userID        (userid who rated)
ideaID        (ideaid of the idea being rated)

So is this approach the best approach here? The only thing I fear is (definitely hypothetical) what if there are 1 million users, and 1 million ideas, and they each make ratings on many ideas. This means there will be millions of records in the ratings table. Is this still efficient ??

2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by IIM
0

Hey guys,

What are your opinions on rating systems in this case? I have users submitting ideas. Now other users can rate an idea UP or DOWN. I want to keep track of what user rates what idea, up or down, and want to be able to display this information on a page of my site, ordering by highest rated ideas or lowest rated ideas.

Is this the best way to go about this?

[B]IDEAS Table[/B]
ideaID                    (auto increment prim key)
ideaText                   (actual paragraph of text detailing idea)
userID           (userid of user that submitted idea)
[B]RATINGS Table[/B]
ratingID       (auto increment prim key)
rateType       (single boolean, 0 for rate down, 1 for rate up)
userID        (userid who rated)
ideaID        (ideaid of the idea being rated)

So is this approach the best approach here? The only thing I fear is (definitely hypothetical) what if there are 1 million users, and 1 million ideas, and they each make ratings on many ideas. This means there will be millions of records in the ratings table. Is this still efficient ??

nvm i got it. and idk how to mark this as solved

0

To mark thread as solved ...click Here
Another way to mark thread as solved is by clicking on mark this thread as solved at the end of the thread page.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.