halomeny Posted June 23, 2017 Report Share Posted June 23, 2017 (edited) 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 Edited June 23, 2017 by halomeny Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted June 29, 2017 Moderators Report Share Posted June 29, 2017 There is not any easy way to optimize this. You will have to add the airports you need instead of adding airports which are useless. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.