Closed (won't fix)
Project:
Voting API
Version:
master
Component:
Code
Priority:
Normal
Category:
Feature request
Assigned:
Reporter:
Created:
11 Nov 2007 at 10:36 UTC
Updated:
6 Jun 2008 at 02:53 UTC
Is there a way to see the total dayly/weekly/monthly number of fivestar votes on my site?
Thanx..
Comments
Comment #1
quicksketchNeither Fivestar nor VotingAPI (which handles recording votes) supports this capability. Since VotingAPI is actually responsible for storing and retrieving data, I'll move this request to that queue as a new feature.
The trouble with daily/weekly/monthly totals is the amount of information that either needs to be queried or somehow cached. Figuring out total number of votes for a week (by timestamp) then sorting requires a temporary table if we don't have caching (read: horribly slow). The other approach is to build cache tables specifically to store totals in day, week, and month long intervals. Which will be much more efficient on retrieval but a slight increase in resources for inserts.
In the mean time, it's best to know that this currently is not possible without significant enhancements to VotingAPI.
Comment #2
eaton commentedThere's nothing to prevent a module from using its own SQL to pull that information out of the VotingAPI tables, but at present there are no plans to include the functionality in VotingAPI directly.