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!
Kawaii or NOT?!
Rei wished Monkey D. Luffy a Happy Birthday
|
LoganTheWarlord joined a Dragon Battle
|
Pinkanimefugger found a Dragon Slayer Candidate Arisu Arishima
|
Pinkanimefugger rated ONIMAI: I'm Now Your Sister! ★★★★★
|
Pinkanimefugger faved Momiji Hozuki
|
| BlackMamba6 joined |
lntrsx rated Osamu Dazai ★★★★★
|
|
lntrsx voted up Osamu Dazai
|
|
lntrsx loved Osamu Dazai
|
|
lntrsx faved Osamu Dazai
|