Skip to content

Name_player incorrect index #214

@erocs

Description

@erocs

Currently Name_player is created with a unique index on (uuid, player) and no primary key. Instead, it should have a unique index on (uuid) to prevent duplicate UUID mappings, change the existing (uuid, player) index to be non-unique for supporting player lookups by uuids, and add a non-unique (player, uuid) index to facilitate uuid lookups by player name. The latter two are non-unique to speed up operations and because the UUIDs are always unique these entries will always be as well.

A primary key should not be used on this table because that would force record ordering. For random data like uuids, that would cause the table to be rebuilt often to create space for new rows in the ordering.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions