Skip to content

create a new mat view for the main query #70

@havok2063

Description

@havok2063

create a new materialized view in the pipelines database that contains all the columns that one can currently search on in zora. this will make queries faster for the main search form, especially ones on program or carton, which involve many joins. this view may get replaced by the allspec or mutliplex table.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions