Skip to content

Performance issues #125

@icydee

Description

@icydee

A ticket to hold a list of observed performance issues that do not warrant their own ticket.

Some of these can be identified by tailing the mysql slow query log at /var/lib/mysql/us1-db1-slow.log

  • DB/Result/Mission.pm - find_body_target this results in a slow query, 45 seconds typical, searching 1.5M records. Since it is potentially called every hour, for every zone, then it takes a big hit.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions