I am looking to speed up querying of records from a specific date range.
My table has millions of rows and the dates are in Unix epoch format, in text format IIRC ( i don't work weekends so can't be certain)
I am pulling in a single schedule record, which has an unique ID field attributed to it.
This ID field is recognised in a separate table called movement, and this movement field stores movement and timing data for the schedule.
Each schedule has its associated movement rows (usually…
Optimising query for date based selecting