Changes to working script

We have a working script that displays all timetables within a given radius of a location, and then displays the results in XML format. We would like to make 2 changes to this script: 1. Speed up project to a few seconds. Here are some suggestions: a) create indexes after the tables are uploaded by the script b) do not perform full table scans of the route tables 2. The script searches for timetables in individual countries. We would like to search for timetables across multiple countries using the following method: a) on upload of all tables (apart from stops table), change the file names to [zip name]_table - eg. uk_stop_times b) use the set of tables to search for routes based on the departure stop (eg. if it is a UK departure stop, use the uk_* tables) c) if there are departure stops from eg. uk and france, the uk stops should search the uk tables for routes, the france should search france tables, and display the results in the same xml response