|
smh if you don't maintain a userstyle mine makes the post font bigger
|
# ¿ Oct 2, 2017 19:15 |
|
|
# ¿ May 10, 2024 15:47 |
|
Glorgnole posted:lol that it's possible to erase an entire user and all their posts, and that doing this extremely breaks threads they posted in i mean, `delete from comments where user_id=69` and it also makes sense that decade-old forum software on mysql with a bunch of denormalization into memcache tacked on would have issues
|
# ¿ Oct 5, 2017 14:01 |
|
stinch posted:another forum i used to visit a similar thing would happen. the number of posts in a thread was stored somewhere, i guess for optimisation. weird stuff happens and the pre calculated value gets out of sync, now the thread pagination is messed up. yeah it usually gets denormalized on to the thread model so you can show the post count and page links in the forum index without a bunch of extra disk seeks
|
# ¿ Oct 7, 2017 17:15 |
|
Roosevelt posted:genuinely curious how this optimizes anything you have to seek to (an index on) the posts table (which is the biggest and busiest table) to count the posts in a thread you seek to 40 rows in the threads table to load the thread index in a forum if you want to load counts for those that's another 40 hits on a posts index forumdisplay.php gets hit more than newreply.php (under non-fucky operation) the count only changes when newreply.php is hit therefore you can save a lot of index hits by storing the post count on the threads table and only updating it when necessary
|
# ¿ Oct 7, 2017 17:40 |
|
if it was on a good database and not mysql you'd have a matview for the thread index that calculates and updates post counts without a lock whenever the posts table is inserted, updated, or deleted
|
# ¿ Oct 7, 2017 17:41 |
|
Sagebrush posted:i guess that's why sometimes you get a stuck post huh. the post count gets desynched from the post db? probably, the forums are php and mysql, which are like the opposite of data integrity, and that's without the extra caching layers that represent more places to have inconsistencies
|
# ¿ Oct 7, 2017 18:21 |
|
George posted:amberpos should continue to be a mirror to the users soul was gonna say amberpos renders just great for me
|
# ¿ Oct 9, 2017 22:15 |
|
|
# ¿ May 10, 2024 15:47 |
|
rockford fontgate
|
# ¿ Nov 8, 2017 06:57 |