Trending Games | World of Warcraft | Overwatch | Bless | Guild Wars 2

    Facebook Twitter YouTube YouTube.Gaming Discord
Quick Game Jump
Members:3,753,326 Users Online:0
CCP Games | Official Site
MMORPG | Setting:Sci-Fi | Status:Final  (rel 05/06/03)  | Pub:CCP Games
PVP:Yes | Distribution:Download,Retail | Retail Price:$19.99 | Pay Type:Subscription
System Req: PC Mac Linux | ESRB:TOut of date info? Let us know!

The API Trilogy

Posted by Suzie Ford on Sep 21, 2010  | Comments

The API Trilogy - EVE Online -

The EVE Online team has a lot of new information about optimizations to the game's API servers for players with a technical bent. Among other things, the team will be contacting developers to correct bad server calls rather than running a wholesale blacklisting of offending servers. Additionally, the team will be deleting old request logs in an effort to streamline things. In between, CCP has a few other ideas.

The logging we use is based on log4net, and it allows players to see the requests that are made against their API keys. The API receives 17-18 million requests every day, which translates into 2-3 GB of data being inserted into a single table per day. This is a considerable amount of data, meaning we have to do a daily purge. This is done by a job that runs every day to delete any data over 7 days old. We've found that this has caused spikes in database response times due to insufficient indexing. In order to solve this, we have to create a new table which has these indexes. This will allow us to clean the table without a considerable performance hit. However given the massive amount of data already existing in the old table, it would take us 3-4 hours to move the data onto the new table.

Read the full blog post here.

Suzie Ford / Suzie is the Associate Editor and News Manager at Follow her on Twitter @MMORPGMom