01-09-2018, 04:49 PM
I made a change to the database, essentially there was one HUGE flight history table that stored flight history for everyone, since the beginning. Well it was very slow to perform queries on the database because there were so many rows. So I made a new table, that only stores the flight history for the past 8 days or so, that's used for demand calculation and such. Then made another table that stored the entire history.
I just need to switch over some things to use the new database table, things like passenger counts and flight counts are still using the table that only stores 8 days of history rather than all the history. But I think I want to change the way the game looks up those data points entirely, and just add a counter to each airline rather than querying the database every time you open up your airline overview page.
It'll probably be back to normal soon, I just haven't got around to it yet
I just need to switch over some things to use the new database table, things like passenger counts and flight counts are still using the table that only stores 8 days of history rather than all the history. But I think I want to change the way the game looks up those data points entirely, and just add a counter to each airline rather than querying the database every time you open up your airline overview page.
It'll probably be back to normal soon, I just haven't got around to it yet
I am the developer of Airline Enterprise