Skip to content

Add index for 'occured_on' column in events tables #167

Description

@miterst

I see that the query to reproject all the events is using the "select-all" query:

SELECT * FROM {} ORDER BY occurred_on, sequence_number ASC

Probably we need to add an index for occurred_on otherwise this can become quite slow if we have to reproject a lot of events.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    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