Issue or Question or ?: large gtfs without calendar (only calendar_dates)

[vingerha]

Hi,
I am remodelling the gtfs solution in HomeAssistant and have a use case with a large file from the NL, the sqlite turns into 7Gb.
As this dataset does not contain calendar entries, I need to rewrite the query to compensate for that and since sqlite does not allow outer joins I need to run it twice with an UNION ALL. Due to the large amount of data the query is pretty slow (db browser : 20-23 sec) and I was wondering if I could optimize this wqith indexes. This I will do myself but 2 questions:

• can you easily add indexes for pytgts, else I need to add them to my solution which I would not prefer
• would yo umaybe know of a way to construct the calendar with only calendar_dates entries? I may try myself but asking first

[vingerha]

Massive improvement is by adding a idx on stop_times stop_id and trip_id...query goes to below 1s

[vingerha]

Sorry, closed incorrectly