Adds a unique index to base_result.hash_index. This field is used in de-duplicating procedures, so may have been a source of slowdown. This is only temporary, as we are working towards removing indices for that use case.
This also fixes/adds indices on access_log (adds one for access_type. The old index named access_type was actually the date).
Description
Adds database indices for access_log and base_result.hash_index
Adds a unique index to
base_result.hash_index
. This field is used in de-duplicating procedures, so may have been a source of slowdown. This is only temporary, as we are working towards removing indices for that use case.This also fixes/adds indices on access_log (adds one for
access_type
. The old index named access_type was actually the date).Description
Adds database indices for access_log and base_result.hash_index
Changelog description
Status