Marcin Łabanowski

Results 24 comments of Marcin Łabanowski

memcached is already partially supported. 8chan uses APC for caching now tho.

it can, longtable just requires that the rows have the same height

nope, you can do create table `posts` select (... a union select query ...), this will offload the hurdle of joining everything to mysql, so it will be a lot...

but a major problem here is that a lot of code is written with assumption that all posts are in different tables. so a major rewrite has to happen

anonfagola: [chax@zbox 8chan]$ grep -Rl posts_%s . ./boards.php ./claim-old.php ./expire.php ./inc/functions.php ./inc/instance-config.php ./inc/mod/pages.php ./install.php ./post.php ./search.php ./templates/themes/catalog/theme.php ./templates/themes/recent/theme.php ./templates/themes/sitemap/theme.php ./templates/themes/ukko/theme.php ./tools/delete-stray-images.php ./tools/rebuild.php ./tools/recount-bumps.php ./tools/stats.php [chax@zbox 8chan]$

haha, you did a merge 2 hours ago and it included a commit "fixes #29", so github treated it as if this commit fixed issue #29. i will do fixes...

myisam is good for tables where there are only inserts and no deletes innodb/xtradb won't cause any problems. there may be issues with fulltext search in certain mysql/mariadb versions, but...

well, RHEL 7 and a recent OpenSUSE/SuSE have mariadb instead of mysql, is it stable enough then? it's just ubuntu sticking with mysql, like with upstart, mir, unity, ..., ok,...

why can't you just add an SQL string field string `board` to the unified schema and make both board and post_id an unique id?

looking at your code, i will add the following: - why leave the sprintf, when you can actually get rid of it? - replace ```posts_%s``` with ```posts``` actually, and not...