Jump to content

halomeny

Members
  • Posts

    3
  • Joined

  • Last visited

Posts posted by halomeny

  1. 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

×
×
  • Create New...