[CONFIRMED] Passenger/Number of Flights Total

[PolarMonkey]

I noticed today that the total number of passengers and flights shows on the main airline overview page has been lowered, by a lot.  I don't know how many passengers and flights I had, but another example is Delta, they had over 3 million passengers back at the end of November, and now it is showing just under 350k.


I know this is probably a low priority now, but maybe it could be somehow linked to the other issues that had been going on lately, who knows.

[Unknown98]

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