search

CUTR-at-USF / ontime-performance-calculator

An application to calculate on-time performance using archived GTFS-realtime data
Other
4 stars 2 forks source link

'ORDER BY' in SELECT SQL query in FeedProcessor.java is not required #1

Closed mohangandhiGH closed 7 years ago

mohangandhiGH commented 7 years ago

However, we are bringing all the records from database that falls between the service start and end range of GTFS static data, the order by in the select sql query is not required. Moreover, removing ORDER BY from query brings the results from server faster than with order by in query

barbeau commented 7 years ago

For now we can remove the ORDER BY query. If in the future we want to add it back, to increase performance we could add an index to the timestamp field in the database table.