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)