Working with GTFS

I am working on GTFS ( General Transit Feed Specification) and have data in .txt file.

Issue: I converted txt files in json and then sql to start with but queries and joins takes five min dues to large records across multiple tables (818,103 rows).

So my question is: how to improve quires in this kind of situations?

Will Postgrad will be faster than MySql in this situation?
Is there any way we can use txt file as database? and if there is whats a best way to use txt files as a database and will it be fast?

If anyone has work with GTFS previously, Please leave any tips that might help :)

rrrrando

7 years ago

Level 10

Did you get anywhere with this?

Please or to participate in this conversation.