Skip to content

Server: tables & queries improvements #31

@gillchristian

Description

@gillchristian

Currently the table structure and the queries aren't very efficient.

  • Add a TTL and cleanup links after?
  • Store stats in a separate table instead of performing calculations on the shortened links table
  • Paginate the list links endpoint
  • Add creation / update dates colums to shortened table
  • Add indexes to shortened commonly queried columns

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions