chia-blockchain icon indicating copy to clipboard operation
chia-blockchain copied to clipboard

Dl wallet store index fix

Open neurosis69 opened this issue 2 years ago • 0 comments

  • renamed the indexes according to #13304
  • removed index coin_id as there is already an internal index for the PK: sqlite_autoindex_singleton_records_1
  • removed index inner_puzzle_hash as I found no SQL query using it
  • fixed wrong indexed column for index confirmed_at_height, indexed column was root
  • removed index id as there is already an internal index for the PK: sqlite_autoindex_launchers_1
  • added index mirrors_launcher_id_index as there is a query here which would benefit from it

neurosis69 avatar Sep 02 '22 22:09 neurosis69