HomePhorge

Schema: Drop unused and useless indexes of sites table

This commit no longer exists in the repository. It may have been part of a branch which was deleted.

Description

Schema: Drop unused and useless indexes of sites table

This table has eight indexes plus PK. It has around 1000 rows only. Even
if it needs these indexes (which it doesn't), they are still useless.

Looking at the code, the only potential useful index is the one on
site_global_key, they are showing up in the report of unused indexes in
the db and I checked with Fandom (which might benefit from an index on
this table) and they said they don't use sites table.

Bug: T342856
Change-Id: I06b3db0f33bd35bfa68f4b418d8c2f4b9b988409

Details

Provenance
Amir SarabadaniAuthored on Feb 1 2024, 1:43 PM

Event Timeline

Amir Sarabadani <ladsgroup@gmail.com> committed rMW616744db1d7d: Schema: Drop unused and useless indexes of sites table (authored by Amir Sarabadani <ladsgroup@gmail.com>).Feb 1 2024, 2:32 PM

Commit No Longer Exists

This commit no longer exists in the repository.