• News
• New
• Index
• About

Most Viewed Characters is back!

It'll update daily with the most viewed characters today.

--

Originally I kept the page views in the character table, but due to the nature of MyISAM tables this lead to a lot of database locks

Each update on a character's view count would stall all reads and writes until it was completed. Which was okay until we had something like 10 updates per second on a database of over 50,000 characters. Eventually indexes would need to be rebuilt, and the whole thing would grind to a halt for several seconds.

This time I'm trying a separate table ... that tracks views for a specific day only. Small data set. Likely much faster with less locking.

Hope it works!