Missing index on series column in mh_search

Description

mh_search has a series_id column, which should be indexed because SearchServiceDatabaseImpl.java runs the query Search.getNoSeries which queries for series missing a series id. Without this index, the db does a full table scan.

If you have a lot of episodes without a series, this could also be a performance concern (for every startup) regardless of the index.

Status

Assignee

Unassigned

Reporter

Stephen Marquard

Tags (folksonomy)

None

Components

Fix versions

Affects versions

Priority

Major
Configure