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

damienmckenna’s picture

damienmckenna
Location TN, USA
commented
Status: Active » Needs work

This needs to be compiled into a valid patch.

ferrangil’s picture

ferrangil commented

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

eaton’s picture

eaton commented
Status: Needs work » Closed (won't fix)

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.