A single and multiplayer BMX game was created to promote the BMX Track at Platt Fields in Manchester. The BMX game was build in Flash and used server-side software to allow up to four players to race simultaneously. The application was build using a combination of PHP, Flash and JavaScript.
The PHP code and integration between the application and Flash was coded by a colleague and myself. Complex integration was required with Flash and the database, in order to save the best times, user information and maintaining user sessions. The leaderboard and other aspects of the application were created in PHP too.
My main involvement in this project was optimizing the PHP code and SQL queries. During load testing, the leaderboard struggled in loading a large number of scores. I successfully optimized the SQL query used to obtain the results and efficiently output the results.