I can’t believe it’s just me, but I’m seeing a lot of HTTP Status 504 (Gateway Time-out) when selecting a country such as United Kingdom on the FlightAware ADS-B Statistics.
Suspect the query is probably not using a primary key or an alternate index on the database.
Now we have 21K participants and growing, perhaps the country query needs optimising?
Selecting “All” works reasonably well, but I’m interested in UK only and that’s taking > 30 secs so I get a 504 instead of a ranking answer that I am looking for.
Is there any other more efficient query that I can do to find my rank in country? Thanks.