Add indexing to votingapi_cache
DamienMcKenna - April 4, 2009 - 21:38
| Project: | Voting API |
| Version: | 5.x-1.6 |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | needs work |
Jump to:
Description
The votingapi_cache table could use some indexing:
ALTER TABLE votingapi_cache
ADD INDEX votingapicache_group (content_id, content_type, value_type, tag, function);
#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