Forum Migration

The school experience. School related queries, discussions, and stories that aren't specific to a subject.

Moderators: gmalivuk, Moderators General, Prelates

User avatar
Flumble
Yes Man
Posts: 1925
Joined: Sun Aug 05, 2012 9:35 pm UTC

Re: Forum Migration

Postby Flumble » Fri Apr 08, 2016 10:17 am UTC

Neil_Boekend wrote:What kind of booze would increase the chances?

"depends on the person"; I think it was Angua who doesn't respond well to alcoholic offerings.
IIRC this has been answered in Madness threads, but those are of course hidden to us mortals.

User avatar
Giant Speck
Bouncy Sex Marshmallow
Posts: 3795
Joined: Tue Sep 08, 2009 12:30 pm UTC
Location: Honolulu ⇒ Tucson

Re: Forum Migration

Postby Giant Speck » Fri Apr 08, 2016 10:57 am UTC

gmalivuk wrote:Returning any kind of search would be a nice start.

Yep. The fact that search doesn't work in any capacity has severely limited my participation here for the past several days.

phlip wrote:Also: you can request things. Just don't necessarily expect that request to be fulfilled.

I'd love to request Tapatalk support and would gladly back such support with the necessary finances.
"Did I say recently that I love Giant Speck? Because I love Giant Speck. He is the best." - Weeks

User avatar
Thesh
Made to Fuck Dinosaurs
Posts: 5393
Joined: Tue Jan 12, 2010 1:55 am UTC
Location: Colorado

Re: Forum Migration

Postby Thesh » Fri Apr 08, 2016 4:46 pm UTC

As I said before, the only thing missing from this site is something that nags you to download a mobile app.
Honesty replaced by greed, they gave us the reason to fight and bleed
They try to torch our faith and hope, spit at our presence and detest our goals

User avatar
Jplus
Posts: 1692
Joined: Wed Apr 21, 2010 12:29 pm UTC
Location: Netherlands

Re: Forum Migration

Postby Jplus » Fri Apr 08, 2016 6:25 pm UTC

Let's exercise patience and respect davean for everything he's already done. He doesn't need reminders of issues that have already been reported (even if they are meant as a joke).
Last edited by Jplus on Fri Apr 08, 2016 11:28 pm UTC, edited 1 time in total.
"There are only two hard problems in computer science: cache coherence, naming things, and off-by-one errors." (Phil Karlton and Leon Bambrick)

coding and xkcd combined

(Julian/Julian's)

User avatar
Thesh
Made to Fuck Dinosaurs
Posts: 5393
Joined: Tue Jan 12, 2010 1:55 am UTC
Location: Colorado

Re: Forum Migration

Postby Thesh » Fri Apr 08, 2016 7:15 pm UTC

Jplus wrote:respect Davean
Honesty replaced by greed, they gave us the reason to fight and bleed
They try to torch our faith and hope, spit at our presence and detest our goals

User avatar
gmalivuk
GNU Terry Pratchett
Posts: 25731
Joined: Wed Feb 28, 2007 6:02 pm UTC
Location: Here and There
Contact:

Re: Forum Migration

Postby gmalivuk » Fri Apr 08, 2016 7:24 pm UTC

I'm not sure spelling davean's name wrong is the best way to show respect.

Thesh wrote:As I said before, the only thing missing from this site is something that nags you to download a mobile app.
If that happens, I'm personally deleting Giant Speck's account and post history before joining up with ST for some murder.
Unless stated otherwise, I do not care whether a statement, by itself, constitutes a persuasive political argument. I care whether it's true.
---
If this post has math that doesn't work for you, use TeX the World for Firefox or Chrome

(he/him/his)

User avatar
SecondTalon
SexyTalon
Posts: 25559
Joined: Sat May 05, 2007 2:10 pm UTC
Location: Louisville, Kentucky, USA, Mars. HA!
Contact:

Re: Forum Migration

Postby SecondTalon » Fri Apr 08, 2016 8:28 pm UTC

Can we do it underwater? (NSFW, cartoon breasts. The violence is A-OK for the workplace)
heuristically_alone wrote:I want to write a DnD campaign and play it by myself and DM it myself.
heuristically_alone wrote:I have been informed that this is called writing a book.

User avatar
gmalivuk
GNU Terry Pratchett
Posts: 25731
Joined: Wed Feb 28, 2007 6:02 pm UTC
Location: Here and There
Contact:

Re: Forum Migration

Postby gmalivuk » Fri Apr 08, 2016 9:13 pm UTC

Unless stated otherwise, I do not care whether a statement, by itself, constitutes a persuasive political argument. I care whether it's true.
---
If this post has math that doesn't work for you, use TeX the World for Firefox or Chrome

(he/him/his)

User avatar
SecondTalon
SexyTalon
Posts: 25559
Joined: Sat May 05, 2007 2:10 pm UTC
Location: Louisville, Kentucky, USA, Mars. HA!
Contact:

Re: Forum Migration

Postby SecondTalon » Fri Apr 08, 2016 9:25 pm UTC

I didn't even notice that. Thanks, Gmal.
heuristically_alone wrote:I want to write a DnD campaign and play it by myself and DM it myself.
heuristically_alone wrote:I have been informed that this is called writing a book.

User avatar
Flumble
Yes Man
Posts: 1925
Joined: Sun Aug 05, 2012 9:35 pm UTC

Re: Forum Migration

Postby Flumble » Fri Apr 08, 2016 10:00 pm UTC

And here is one without the 'adult content' flag. (so you can enjoy* it without logging into you overlord google account)

*enjoyment is not guaranteed; I think dethklok is a bit bland and too fast

User avatar
Jplus
Posts: 1692
Joined: Wed Apr 21, 2010 12:29 pm UTC
Location: Netherlands

Re: Forum Migration

Postby Jplus » Fri Apr 08, 2016 11:30 pm UTC

Thesh wrote:
Jplus wrote:respect Davean

gmalivuk wrote:I'm not sure spelling davean's name wrong is the best way to show respect.

Sorry, davean. I changed my original post.
"There are only two hard problems in computer science: cache coherence, naming things, and off-by-one errors." (Phil Karlton and Leon Bambrick)

coding and xkcd combined

(Julian/Julian's)

User avatar
Pfhorrest
Posts: 3717
Joined: Fri Oct 30, 2009 6:11 am UTC
Contact:

Re: Forum Migration

Postby Pfhorrest » Sat Apr 09, 2016 12:14 am UTC

browsing mobile for the first time since the change and wow it's a lot better
Forrest Cameranesi, Geek of All Trades
"I am Sam. Sam I am. I do not like trolls, flames, or spam."
The Codex Quaerendae (my philosophy) - The Chronicles of Quelouva (my fiction)

User avatar
Xanthir
My HERO!!!
Posts: 5199
Joined: Tue Feb 20, 2007 12:49 am UTC
Location: The Googleplex
Contact:

Re: Forum Migration

Postby Xanthir » Sat Apr 09, 2016 2:24 pm UTC

flicky1991 wrote:FFT finally loaded for me. I had to wait a while, though.

Me too; FFT is still loading after about a minute.

From what I can tell, the slow-loading threads are the long ones - when the thread builds up to more than a hundred pages you start getting a noticable slowdown, and it seems to be proportional to the length (the Minecraft thread in Gaming also took ~15s to load). This suggests there's something wrong with the DB queries that's making it do something per-page, or possibly a query goes quadratic in the thread length with a badly-structured JOIN.

(I know it's nothing to do with my connection speed; I just got a significant home internet upgrade last week and the behavior is roughly identical.)
(defun fibs (n &optional (a 1) (b 1)) (take n (unfold '+ a b)))

User avatar
Giant Speck
Bouncy Sex Marshmallow
Posts: 3795
Joined: Tue Sep 08, 2009 12:30 pm UTC
Location: Honolulu ⇒ Tucson

Re: Forum Migration

Postby Giant Speck » Sat Apr 09, 2016 9:54 pm UTC

gmalivuk wrote:I'm not sure spelling davean's name wrong is the best way to show respect.

Thesh wrote:As I said before, the only thing missing from this site is something that nags you to download a mobile app.
If that happens, I'm personally deleting Giant Speck's account and post history before joining up with ST for some murder.

Image

Had I known the notification couldn't be turned off by the administrator, I wouldn't have suggested it. Sorry.
"Did I say recently that I love Giant Speck? Because I love Giant Speck. He is the best." - Weeks

User avatar
gmalivuk
GNU Terry Pratchett
Posts: 25731
Joined: Wed Feb 28, 2007 6:02 pm UTC
Location: Here and There
Contact:

Re: Forum Migration

Postby gmalivuk » Sat Apr 09, 2016 10:11 pm UTC

Giant Speck wrote:
gmalivuk wrote:I'm not sure spelling davean's name wrong is the best way to show respect.

Thesh wrote:As I said before, the only thing missing from this site is something that nags you to download a mobile app.
If that happens, I'm personally deleting Giant Speck's account and post history before joining up with ST for some murder.

Image

Had I known the notification couldn't be turned off by the administrator, I wouldn't have suggested it. Sorry.

Maybe it can be, hence the "if".
Unless stated otherwise, I do not care whether a statement, by itself, constitutes a persuasive political argument. I care whether it's true.
---
If this post has math that doesn't work for you, use TeX the World for Firefox or Chrome

(he/him/his)

User avatar
Giant Speck
Bouncy Sex Marshmallow
Posts: 3795
Joined: Tue Sep 08, 2009 12:30 pm UTC
Location: Honolulu ⇒ Tucson

Re: Forum Migration

Postby Giant Speck » Sat Apr 09, 2016 10:28 pm UTC

It apparently can be disabled using code, but honestly, if it takes that much more effort to do, then I'm not willing to continue suggesting that he implement it.
"Did I say recently that I love Giant Speck? Because I love Giant Speck. He is the best." - Weeks

User avatar
Soupspoon
You have done something you shouldn't. Or are about to.
Posts: 2312
Joined: Thu Jan 28, 2016 7:00 pm UTC
Location: 53-1

Re: Forum Migration

Postby Soupspoon » Tue Apr 12, 2016 4:29 am UTC

May or may not be related to Forum Migration, or else (being still a relative newbug) even occasionally happened with the pre-Migration forum version, but... this could have a bearing to the Search problems (which stop me easily checking for prior mentions, sorry!), and is definitely something odd.

Composite image here, specifically marked up:
Spoiler:
XKCDMismatch.PNG

Top: Main (top-level) page, section summarising the "The Comic" sub-threads, with "Individual XKCD Comic Threads" noted as having a "Last Post" relating to comic 1583, Eternal Density having posted at a suitably recent timestamp.

Middle:"Individual XKCD Comic Threads" thread-page, indicating that the latest (unstickied) post was by Eternal Density, and at that time, but was in comic 1666's thread.

Bottom: After re-ordering, for ease of searching, 1583's thread is indeed found to be last edited back in last October, nothing like announced on the front page.

(Did not bother to check each and every top-level thread-summary vs. its target, for other mismatches.)

...maybe interesting, probably reproducible, possibly investigateable (at leisure). Hopefully not precipitative towards disabling the front-page summary, for the duration, though... ;)

User avatar
chridd
Has a vermicelli title
Posts: 750
Joined: Tue Aug 19, 2008 10:07 am UTC
Location: ...Earth, I guess?
Contact:

Re: Forum Migration (<- this is the post title)

Postby chridd » Tue Apr 12, 2016 5:37 am UTC

Soupspoon wrote:May or may not be related to Forum Migration, or else (being still a relative newbug) even occasionally happened with the pre-Migration forum version, but... this could have a bearing to the Search problems (which stop me easily checking for prior mentions, sorry!), and is definitely something odd.[...]
Look more closely at the post in question.

That view is showing post titles, rather than topic titles like it used to. Therefore, if someone changes the post title (by editing the "Subject" field in the reply screen) then it'll display whatever title they put. That particular post happens to have a weird title for reasons that may or may not be clear if you read the post itself.
~ chri d. d. /tʃɹɪ.di.di/ (Phonotactics, schmphonotactics) · they (for now, at least) · Forum game scores
mittfh wrote:I wish this post was very quotable...
flicky1991 wrote:In both cases the quote is "I'm being quoted too much!"

User avatar
Soupspoon
You have done something you shouldn't. Or are about to.
Posts: 2312
Joined: Thu Jan 28, 2016 7:00 pm UTC
Location: 53-1

Re: Forum Migration (<- this is the post title)

Postby Soupspoon » Tue Apr 12, 2016 2:00 pm UTC

chridd wrote:That particular post happens to have a weird title for reasons that may or may not be clear if you read the post itself.
Ah, apologies. I did know about the pre-reported 'fault' when it came to Time's contributors' little quirks... And I'd read and appreciated the Brain Upload post concerned, but without noticing how far Eternal had gone with the 'art'...

Carry on, then. Nothing to see here. :P

User avatar
Mikemk
Posts: 113
Joined: Tue Feb 11, 2014 7:10 am UTC
Location: Moving furniture'); DROP TABLE OweMyFoot; --

Re: Forum Migration

Postby Mikemk » Wed Apr 13, 2016 7:22 am UTC

I just noticed that posts in forum games now contribute to your total. (And I can't believe I've been here for months and have less than 100 posts.)

Thesh wrote:As I said before, the only thing missing from this site is something that nags you to download a mobile app.

As long as it redirects to the home page if you click no, I'm cool with that.
Computer specs:
Spoiler:
Intel i5-750 (OC 3.33 GHz)
8GB (OC 1333 MHz) (2GB HDD cache)
NVIDIA GT 740 (OC 1149 MHz) 4GB (OC 841 MHz)
480GB SSD (120 HDD cache)
2x2TB HDD (not RAID)
Windows 10
Linux Mint in VM

User avatar
gmalivuk
GNU Terry Pratchett
Posts: 25731
Joined: Wed Feb 28, 2007 6:02 pm UTC
Location: Here and There
Contact:

Re: Forum Migration

Postby gmalivuk » Wed Apr 13, 2016 11:47 am UTC

Would it also be possible to ensure that it never pops up a second time? I don't care where it redirects me, if it happens more than once it'll be your account I delete before ST and I carry out that hit.
Unless stated otherwise, I do not care whether a statement, by itself, constitutes a persuasive political argument. I care whether it's true.
---
If this post has math that doesn't work for you, use TeX the World for Firefox or Chrome

(he/him/his)

User avatar
SecondTalon
SexyTalon
Posts: 25559
Joined: Sat May 05, 2007 2:10 pm UTC
Location: Louisville, Kentucky, USA, Mars. HA!
Contact:

Re: Forum Migration

Postby SecondTalon » Wed Apr 13, 2016 6:19 pm UTC

In the interest of being fair, the benefits of tapatalk that I'm seeing are

Ad free forums. The xkcd forums don't have ads.

No giant avatars or signatures. Before we get into the rules prohibiting most of those, the new software minimizes that issue. And there has always been the ability to turn them off in your preferences, but that's not ideal as that's universal and applies to your desktop experience too.

Mobile-friendly format. See:the forum now.

Ability to view multiple forums on one page. Okay, we can't do that.

So one benefit that benefits the end user who wants to view multiple forums at once, but not the end user who doesn't. And that's all I'm seeing.

In exchange, davean gets a plugin to dick around with and figure out how to make work (and remember to turn off the fucking thing that harasses you if you use the forum on mobile without tapatalk) while simultaneously creating yet another security flaw.

Not seeing how the one benefit outweighs the many flaws.
heuristically_alone wrote:I want to write a DnD campaign and play it by myself and DM it myself.
heuristically_alone wrote:I have been informed that this is called writing a book.

User avatar
flicky1991
Like in Cinderella?
Posts: 595
Joined: Fri Feb 11, 2011 3:36 pm UTC
Location: London

Re: Forum Migration

Postby flicky1991 » Wed Apr 13, 2016 6:33 pm UTC

Mikemk wrote:I just noticed that posts in forum games now contribute to your total.

I don't think they do. I'd have quite a lot more if they did.
Discord for Forum Games posters
(Please let me know if the link doesn't work)
----
avatar from marionic
----
Carlington wrote:flicky has done it
portmanteau of poo and post
the truest "shit"-post

User avatar
Mikemk
Posts: 113
Joined: Tue Feb 11, 2014 7:10 am UTC
Location: Moving furniture'); DROP TABLE OweMyFoot; --

Re: Forum Migration

Postby Mikemk » Wed Apr 13, 2016 7:31 pm UTC

flicky1991 wrote:
Mikemk wrote:I just noticed that posts in forum games now contribute to your total.

I don't think they do. I'd have quite a lot more if they did.

I think it's only posts posted there after migration that contribute.
Computer specs:
Spoiler:
Intel i5-750 (OC 3.33 GHz)
8GB (OC 1333 MHz) (2GB HDD cache)
NVIDIA GT 740 (OC 1149 MHz) 4GB (OC 841 MHz)
480GB SSD (120 HDD cache)
2x2TB HDD (not RAID)
Windows 10
Linux Mint in VM

User avatar
flicky1991
Like in Cinderella?
Posts: 595
Joined: Fri Feb 11, 2011 3:36 pm UTC
Location: London

Re: Forum Migration

Postby flicky1991 » Wed Apr 13, 2016 7:36 pm UTC

Mikemk wrote:
flicky1991 wrote:
Mikemk wrote:I just noticed that posts in forum games now contribute to your total.

I don't think they do. I'd have quite a lot more if they did.

I think it's only posts posted there after migration that contribute.

Just posted there, nothing changed. Where were you posting that seemed to affect it?
Discord for Forum Games posters
(Please let me know if the link doesn't work)
----
avatar from marionic
----
Carlington wrote:flicky has done it
portmanteau of poo and post
the truest "shit"-post

User avatar
Giant Speck
Bouncy Sex Marshmallow
Posts: 3795
Joined: Tue Sep 08, 2009 12:30 pm UTC
Location: Honolulu ⇒ Tucson

Re: Forum Migration

Postby Giant Speck » Wed Apr 13, 2016 9:25 pm UTC

gmalivuk wrote:Would it also be possible to ensure that it never pops up a second time? I don't care where it redirects me, if it happens more than once it'll be your account I delete before ST and I carry out that hit.

Or we can just forget that I mentioned it.
"Did I say recently that I love Giant Speck? Because I love Giant Speck. He is the best." - Weeks

User avatar
gmalivuk
GNU Terry Pratchett
Posts: 25731
Joined: Wed Feb 28, 2007 6:02 pm UTC
Location: Here and There
Contact:

Re: Forum Migration

Postby gmalivuk » Wed Apr 13, 2016 11:18 pm UTC

Giant Speck wrote:
gmalivuk wrote:Would it also be possible to ensure that it never pops up a second time? I don't care where it redirects me, if it happens more than once it'll be your account I delete before ST and I carry out that hit.

Or we can just forget that I mentioned it.

I already did, which is why I moved my threat along to Mikemk instead.
Unless stated otherwise, I do not care whether a statement, by itself, constitutes a persuasive political argument. I care whether it's true.
---
If this post has math that doesn't work for you, use TeX the World for Firefox or Chrome

(he/him/his)

User avatar
Kewangji
Has Been Touched
Posts: 2201
Joined: Sun Oct 07, 2007 5:20 pm UTC
Location: Lost in Translation
Contact:

Re: Forum Migration

Postby Kewangji » Thu Apr 14, 2016 1:01 pm UTC

I feel bad for reading less and less here but the forums are so slow now. Like, pages take 20 seconds or more to load no matter what network I'm on. I seem to recall they were fine when the migration first happened, although I might be misremembering. I don't know if this has been discussed here? Seems mostly to be focused on the search kaputness. Anyway, thought I'd bring this up. I'm certain y'all are doing everything you can.
If you like my words sign up for my newsletter, Airport Tattoo Parlour: https://tinyletter.com/distantstations

Weeks wrote:One of these days I'm going to slip into your room at night and I'm gonna motorboat you.

User avatar
Zohar
COMMANDER PORN
Posts: 7427
Joined: Fri Apr 27, 2007 8:45 pm UTC
Location: Denver

Re: Forum Migration

Postby Zohar » Thu Apr 14, 2016 1:06 pm UTC

Forum slowness was discussed at least some place (FaiD maybe?). In any case, I actually wanted to report forum seems quicker to me today than previous days. FaiD Fleeting Thoughts is still very slow, but other stuff seems mostly normal.
Mighty Jalapeno: "See, Zohar agrees, and he's nice to people."
SecondTalon: "Still better looking than Jesus."

Not how I say my name

User avatar
bentheimmigrant
Dotcor Good Poster
Posts: 1353
Joined: Fri Apr 25, 2008 9:01 pm UTC
Location: UK

Re: Forum Migration

Postby bentheimmigrant » Thu Apr 14, 2016 1:26 pm UTC

I find slowness generally corresponds to thread size. The big threads (random natterings, rant threads, fleeting thoughts, etc.) are all markedly slower than small ones.
"Comment is free, but facts are sacred" - C.P. Scott

User avatar
Neil_Boekend
Posts: 3215
Joined: Fri Mar 01, 2013 6:35 am UTC
Location: Yes.

Re: Forum Migration

Postby Neil_Boekend » Thu Apr 14, 2016 1:29 pm UTC

Time seems reasonably fast, so that is not an absolute law.
Mikeski wrote:A "What If" update is never late. Nor is it early. It is posted precisely when it should be.

patzer's signature wrote:
flicky1991 wrote:I'm being quoted too much!

he/him/his

User avatar
bentheimmigrant
Dotcor Good Poster
Posts: 1353
Joined: Fri Apr 25, 2008 9:01 pm UTC
Location: UK

Re: Forum Migration

Postby bentheimmigrant » Thu Apr 14, 2016 1:36 pm UTC

Nah, that's just relativity. Time has apparent discrepancies from Newton's first law of Foradynamics: All threads have identical kinetic energy. However, that's because it's Time, when you try to measure its speed (in time), you cancel out either side of the equation, and thus it loads instantly.
"Comment is free, but facts are sacred" - C.P. Scott

User avatar
Flumble
Yes Man
Posts: 1925
Joined: Sun Aug 05, 2012 9:35 pm UTC

Re: Forum Migration

Postby Flumble » Thu Apr 14, 2016 3:11 pm UTC

I hypothesize that long threads load slowly when you're the first to view it after a modification, as if the server caches/optimizes a thread once it's viewed in the current state.
Hypothesis the second is that it is dependent on forum load and when you request a (long) thread during high load, it may have to cache your query results to disk making it incredibly slow.
Hypothesis the third is that the forum just adds a random delay when requesting a thread because fuck you.

In any case I have found the load times to correlate with thread size, too.

User avatar
Soupspoon
You have done something you shouldn't. Or are about to.
Posts: 2312
Joined: Thu Jan 28, 2016 7:00 pm UTC
Location: 53-1

Re: Forum Migration

Postby Soupspoon » Thu Apr 14, 2016 3:14 pm UTC

Kewangji wrote:I feel bad for reading less and less here but the forums are so slow now. Like, pages take 20 seconds or more to load no matter what network I'm on.
How many Gardens do you have active? ;)

(They do seem to be resource-hogs. I can't actually afford to keep them running, 24/7, because they cause problems all across my browsers. "This script is taking a long time to run" errors on unrelated tabs, etc, which I traditionally keep running in parallel with no(/few) prior problems...)

Not that I think this is much to do with the Migration, but...

User avatar
SecondTalon
SexyTalon
Posts: 25559
Joined: Sat May 05, 2007 2:10 pm UTC
Location: Louisville, Kentucky, USA, Mars. HA!
Contact:

Re: Forum Migration

Postby SecondTalon » Thu Apr 14, 2016 5:18 pm UTC

Re: Forum Slowness

In the olden times of the long long ago, before even I walked this landscape, threads were shut down and locked or migrated after so many replies were made (hence things like the Introduction thread being Intro Thread The Third) because of forum weirdness making threads or the whole forum or whatever slow.

Later versions of php or whatever cleared that problem up.

We may be entering a time when the tools and rules of the dark ages are needed once again.

Or, y'know, maybe it'll clear up after the search thing gets fixed. I'm not 100% sure on davean's priority order here, as I know dick about phpbb, much less what the problem(s) are in play here. Could be whatever thing he fixes will just magically make all the problems vanish, or.. I dunno, he's doing all he can just to keep the thing up and running and will work on fixing issues when that's resolved.

Hell, I don't know how much the garden issues have distracted from fixing the forum.

At any rate, it's something that I know has been bouncing around my head - big threads = slow, so we should discourage large threads.

Not a goddamn clue what to do about TIME. I'm not even sure handing them their own subforum would be a good idea as a lot of the culture and interaction is based on everything being part of the same long, unbroken string.
heuristically_alone wrote:I want to write a DnD campaign and play it by myself and DM it myself.
heuristically_alone wrote:I have been informed that this is called writing a book.

User avatar
Neil_Boekend
Posts: 3215
Joined: Fri Mar 01, 2013 6:35 am UTC
Location: Yes.

Re: Forum Migration

Postby Neil_Boekend » Thu Apr 14, 2016 5:57 pm UTC

Thank you davean for fixing the speed.
Mikeski wrote:A "What If" update is never late. Nor is it early. It is posted precisely when it should be.

patzer's signature wrote:
flicky1991 wrote:I'm being quoted too much!

he/him/his

User avatar
Xanthir
My HERO!!!
Posts: 5199
Joined: Tue Feb 20, 2007 12:49 am UTC
Location: The Googleplex
Contact:

Re: Forum Migration

Postby Xanthir » Thu Apr 14, 2016 6:51 pm UTC

OMIGOD FFT LOADS IMMEDIATELY AGAIN

This is great, davean is great, everything is great.
(defun fibs (n &optional (a 1) (b 1)) (take n (unfold '+ a b)))

User avatar
davean
Site Ninja
Posts: 2495
Joined: Sat Apr 08, 2006 7:50 am UTC
Contact:

Re: Forum Migration

Postby davean » Fri Apr 15, 2016 5:38 am UTC

Xanthir wrote:
flicky1991 wrote:FFT finally loaded for me. I had to wait a while, though.

Me too; FFT is still loading after about a minute.

From what I can tell, the slow-loading threads are the long ones - when the thread builds up to more than a hundred pages you start getting a noticable slowdown, and it seems to be proportional to the length (the Minecraft thread in Gaming also took ~15s to load).


So ... when you load a thread, phpbb is now selecting a list of every post id in said thread, ordered. So, whats the solution? Well, making sure it all just fits in memory works wonders. I have no idea why they programmed it like that though.

Hopefully the search index will be rebuilt by morning. Then I can turn the search back on and we can see if stuff breaks again.

User avatar
Thesh
Made to Fuck Dinosaurs
Posts: 5393
Joined: Tue Jan 12, 2010 1:55 am UTC
Location: Colorado

Re: Forum Migration

Postby Thesh » Fri Apr 15, 2016 6:43 am UTC

davean wrote:So ... when you load a thread, phpbb is now selecting a list of every post id in said thread, ordered. So, whats the solution? Well, making sure it all just fits in memory works wonders. I have no idea why they programmed it like that though.


My guess is that they wanted an efficient way to find page number by post id, without having to store the relative post number in the database (which would have to be updated every time a post is deleted), since MySQL doesn't have a row_number function like PostgreSQL, SQL Server, or Oracle.

Note, that even that's not a good excuse if that's the case since you can just do a count where the post id is less than or equal to that value and it's in a particular thread.
Honesty replaced by greed, they gave us the reason to fight and bleed
They try to torch our faith and hope, spit at our presence and detest our goals

User avatar
Neil_Boekend
Posts: 3215
Joined: Fri Mar 01, 2013 6:35 am UTC
Location: Yes.

Re: Forum Migration

Postby Neil_Boekend » Fri Apr 15, 2016 7:43 am UTC

I kinda prefer a fast forum over having a post number.
Mikeski wrote:A "What If" update is never late. Nor is it early. It is posted precisely when it should be.

patzer's signature wrote:
flicky1991 wrote:I'm being quoted too much!

he/him/his


Return to “School”

Who is online

Users browsing this forum: No registered users and 4 guests