Amir Ghezelbash wrote:
Hi Mark,
Thank you for your reply..users do have accounts...but my problem is how
to keep track of what user has voted for what product..i mean i dont
really want it to get into Sql sever..becuase it would just be a huge db
filler..you know all users ...all products..what products have
voted..what users have voted for that specific product...all too
overwhleming...is there an easy way of doing this?
---
Best Regards
Amir
*** Sent via Developersdex http://www.developersdex.com ***
There are only so many ways to do something like this:
-Cookies (not really effective like you said)
-Tracking by IP (quite bad too, lots of people can share the same IP on
some networks, ppl can use proxies to cheat the system still, ppl on
dialup with dynamic IPs, etc)
-And the old tracking with a database... A simple table like this should
work:
[ID] ID/pri key of ratings table (could do without if you wanted to...)
[UserID] FK to user's table
[ProductID] FK to products table
[Rating] the rating/vote itself
But yes, it can grow quite a lot (you could theorically have as many
rows in it than total_users*total_products; although that won't happen
it can get quite huge if site is big and popular), more burden on the DB
itself, more queries executed per page, more code, more sprocs, more
business logic/rules, more unit tests, more bugs to fix, etc. It's not
that huge or overwhelming, but I can see why you don't really feel like
it either, but it's the only real way to do this unfortunately.