Tickets In Stock - How we made it
ZX Development created a system where events, venues, and tickets are all represented by readable (and search engine friendly) links. Venue and event description data are downloaded regularly, and stored within the site's MySQL database. Ticket availability information is downloaded directly from EventInventory for each customer inquiry. We had originally attempted to cache ticket information in the database as well, but the request load was excessive for the EventInventory server, and the staff there asked us to stop.
We reused the ticket caching component later on, when it was decided to export ticket information to product listing services such as Oodle and Google Base. ZX Development reduced the load on the EventInventory servers by only running the ticket download once per day, and introduced a wait period between each request. Once the data has been downloaded into the database a series of scripts are run to generate a special XML file for each product listing service, which is then downloaded from the site and uploaded to the service.
Tags:




