Fox Sports Fantasy Football gives sports fans the opportunity to create their own leagues and manage their own teams based on the real-world performance of the players. Sports statistics are the foundation on which players choose their Fantasy Football team rosters. The Fantasy Football Player Page gives subscribers access to all NFL players and their entire collection of statistics in a unified interface. Subscribers can easily sort and compare players. During this process, 1 MB of data is transferred between the server and the user’s web client and can take over a minute. Sixty seconds is a long time when it comes to gaming and can negatively impact visitor volume and advertising revenue.
With game day web requests exceeding 40,000 per second, response times for Fox Sports fantasy football games are critical to user experience. Increasingly slow response times from their Oracle database required immediate attention. Pythian had the solution.
What we did
Reviewed the application business logic to understand the application, database, web client relationship, and performance criteria
Recommended application modifications so end-user server statistics were processed in the Oracle database server instead of the web client
Worked with the client’s developers to modify the Java UI and PL/SQL database code
Technologies used
Oracle Database Server
Oracle PL/SQL
Key Outcomes
We have been using Oracle services at Pythian for more than seven years. They arevery professional and highly skilled experts in the Oracle field. I appreciate their excellent support over the years.
– Nhu Nguyen, Manager, Data Operations, Fox Sports Interactive Media
