Return to the Press page

Vyatta – Linux & Open Source Alternative to Cisco – Advanced Routing, Firewall, VPN, QoS..
Free Download ->

LWN.net Weekly Edition for October 2, 2008

openSUSE and the distribution of proprietary software

Weekly edition	Kernel	Security	Distributions	Search
Archives	Calendar	Subscribe	Write for LWN	LWN.net FAQ

How to Optimize Rank Data in MySQL (O'ReillyNet)

[Posted March 5, 2007 by cook]

Baron Schwartz discusses the use and optimization of DBMS software in the context of online gaming. "Imagine a site that keeps track of gamers' scores in computer games and displays gamers in "leaderboards" ordered by decreasing score. The site is written in PHP and the backend is a MySQL 5 database server. Because the data changes frequently, the server uses the InnoDB storage engine."

(Log in to post comments)