Hi
When we set up our PHPVMS site we were feeling lazy, and so imported a list of all the airports in the world.
Big mistake.
Our list of airports, when searching for flights is incredibly slow (it takes 5 minutes to fully load). To start combating this, we started querying and deleting airports that weren't gonna be used (ones from Syria n stuff)
Aside from finding more batches to delete, is there any way to optimize this?
https://gyazo.com/1d991bdba7d4d564798552c38811e029 (Sort of an example, but it takes so long to show the names I cant fit it into a gif)
Michael