Posted by DamienMcKenna on April 4, 2009 at 9:38pm
Jump to:
| Project: | Voting API |
| Version: | 5.x-1.6 |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (won't fix) |
Issue Summary
The votingapi_cache table could use some indexing:
ALTER TABLE votingapi_cache
ADD INDEX votingapicache_group (content_id, content_type, value_type, tag, function);
Comments
#1
This needs to be compiled into a valid patch.
#2
This looks interesting!!
Did you notice any improvement?
My site has lots of views sorted by voting average and then voting count... most of the queries are querying votingapi_cache... I have around 80.000 rows.
Thanks
#3
Support for the 5.x branch of VotingAPI has ended with the release of Drupal 7 and the upcoming release of VotingAPI 7.x-2.4.