~mil/mobroute-tickets#98: 
Mobroute: Generated calendar to services perf (_vcaltoservice view)

Tracking ticket to improve performance of the _vcaltoservice view.

The view _vcaltoservice expands for each single calendar day, the associated services based on both calendar and calendar_dates. This is necessary as this work needs to be done either way for routing logic (see CSA connections DB query). Perf generally needs to be re-examined for _vcaltoservice as creating this view (and computed table _cvcaltoservice) can be quite a bit slow for certain GTFS archives.

Note: for feeds that have arbitrarily high end_date(s) in the GTFS calendar table, this can dramatically effect performance. E.g. set end_date to 4000 in calendar_dates for example.

Status
REPORTED
Submitter
~mil
Assigned to
No-one
Submitted
12 days ago
Updated
11 days ago
Labels
mobroute pending-release performance release:0.8

~mil 11 days ago

Fixed via ac7c4ce8b220c1e02c64c7ce4c9453a432bbd01e

Register here or Log in to comment, or comment via email.