Hi,

I run www.fsdaily.com , a very busy website.
I am also developing a karma module based on the VotingAPI.

Whenever somebody votes for a comment or a node, a vote for that particular user is automatically added.

I am a little concerned about performance. A user will end up getting between 4000 and 8000 votes after a little while. Right now, votingapi_recalculate_results() calls _votingapi_get_raw_votes which can become a bit of a performance issue.

I can get around it by NOT adding a vote for the user, but forcing something into the cache by calling _votingapi_insert_cache_result() - the karma would be calculated by an SQL query.

Do you think that would be a little too horrific?

Bye,

Merc.

Comments

mercmobily’s picture

mercmobily commented

Hi,

I just wanted to let you know that I solved this issue.
Basically, the user_karma module create a custom vote with the karma value. For each entry, there will also be an entry in the cache table.

So, it works - have a look at the user_karma module if you have a minute!

Merc.

eaton’s picture

eaton commented
Status: Active » Fixed

Thanks. This problem is also handled differently in VotingAPI 2.0, and is somewhat more efficient.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.