HSLdevcom / transitlog

Explore observed public transport and compare with the intended traffic
https://reittiloki.hsl.fi/
Creative Commons Attribution 4.0 International
5 stars 1 forks source link

Plan how to insert all history HFP data to production db #20

Open samijuhani opened 5 years ago

paasovaara commented 5 years ago

initial application is done. can now insert events from xz compressed tarballs to timescaledb. insert rate is approx 8500msgs/sec -> ~6-8 times faster than real world scenario. but this is still very slow if we want to import years of data (will take months to insert)

TODO:

TODO design: