Actions
Feature proposal #7619
closed
Implement additional unique indexes
Description
A unique index should be on the likes and follows tables for user id and asset. A user can't like or follow the same asset twice. This would further improve SQL performance, but migration code needs to be implemented to clean up the duplicates first before the index is made unique.
Updated by krileon over 1 year ago
- % Done changed from 0 to 80
Only __comprofiler_plugin_activity_likes and __comprofiler_plugin_activity_following remain needing unique flag on liked and followed indexes. Other tables have had their necessary changes made.
Updated by krileon over 1 year ago
- Status changed from Assigned to Resolved
- % Done changed from 80 to 100
Query for purging duplicates noted in install script and XML index flagged as unique for liked and followed.
Actions