Trending Games | World of Warcraft | Dark and Light | Rift | Wizard101

    Facebook Twitter YouTube Twitch.tv YouTube.Gaming Discord
Username:  Password:   Remember?  
Show Quick Gamelist Jump to Random Game
Members:3,648,888 Users Online:0
Games:945 
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 - MMORPG.com

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.

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