News
| February 6th | Feb 5, 2014 | Rei |
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!
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!