# Board performance problems

**URL:** <https://boards.straightdope.com/t/board-performance-problems/659491>\
**Category:** About This Message Board\
**Created:** [May 27, 2013, 9:15pm UTC](https://boards.straightdope.com/t/board-performance-problems/659491 "2013-05-27T21:15:59Z")\
**Posts on this page:** 20\
**Page:** 5

<div class="post-metadata">

**Author:** ![madrabbitwoman](https://avatars.discourse-cdn.com/v4/letter/m/c37758/32.png) [@madrabbitwoman](https://boards.straightdope.com/u/madrabbitwoman)\
**Post date:** [June 13, 2013, 9:37am UTC](https://boards.straightdope.com/t/board-performance-problems/659491/82 "2013-06-13T09:37:48Z")

</div>

My little bit of weirdness: when I click to go into say - mpsims I get a page with all the stickies and stuff but no threads. I finally worked out that hitting refresh made the threads appear. This is the first problem I have noticed so far.

---

<div class="post-metadata">

**Author:** ![BrainGlutton](https://avatars.discourse-cdn.com/v4/letter/b/82dd89/32.png) [@BrainGlutton](https://boards.straightdope.com/u/BrainGlutton)\
**Post date:** [June 13, 2013, 2:22pm UTC](https://boards.straightdope.com/t/board-performance-problems/659491/83 "2013-06-13T14:22:36Z")

</div>

> [@cochrane](#):
>
> It’s time to get bigger rodents. We need capybaras powering the Dope.

That’s a **start,** but can they be bred with tentacles and poisonous fangs?

What? We need a reason?

---

<div class="post-metadata">

**Author:** ![Musicat](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/musicat/32/20189_2.png) [@Musicat](https://boards.straightdope.com/u/Musicat)\
**Post date:** [June 13, 2013, 3:02pm UTC](https://boards.straightdope.com/t/board-performance-problems/659491/84 "2013-06-13T15:02:33Z")

</div>

> [@Cat\_Whisperer](#):
>
> Today’s irritations - going to a forum keeps on showing me the last posts as having been made June 10th, and a post that I selected for quoting keeps on coming up every time I respond to a thread. And the problem with very few new threads coming up from the “Show New Posts” search continues.

Same here, even though all of my subscribed threads have post-06/10 posts. 06/10 seems to be some magic cutoff date. Did the hamsters escape thru a Tom, Dick or Harry tunnel on that date?

---

<div class="post-metadata">

**Author:** ![AaronX](https://avatars.discourse-cdn.com/v4/letter/a/7bcc69/32.png) [@AaronX](https://boards.straightdope.com/u/AaronX)\
**Post date:** [June 13, 2013, 3:06pm UTC](https://boards.straightdope.com/t/board-performance-problems/659491/85 "2013-06-13T15:06:06Z")

</div>

> [@AaronX](#):
>
> Ok today, a few times when I refreshed a forum, I got a list of posts where the latest post was 7 or 8 am (UTC+8) when the real time was 3 or 4 pm. I thought it was my computer being lazy and serving a cached file instead of refreshing. But when I clicked New Posts on a different computer (around 10 pm), I only got 3 threads, also updated around 7 or 8 am.

That only happened sometimes a few days ago. Today, it’s happening all the time. I never got New Posts to work. Tapatalk is still working, though.

---

<div class="post-metadata">

**Author:** ![Elendil\_s\_Heir](https://avatars.discourse-cdn.com/v4/letter/e/7cd45c/32.png) [@Elendil\_s\_Heir](https://boards.straightdope.com/u/Elendil_s_Heir)\
**Post date:** [June 13, 2013, 3:06pm UTC](https://boards.straightdope.com/t/board-performance-problems/659491/86 "2013-06-13T15:06:25Z")

</div>

The Quote function still isn’t working. I just tried it with **Musicat** ’s post, just above this one.

---

<div class="post-metadata">

**Author:** ![Czarcasm](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/czarcasm/32/4050_2.png) [@Czarcasm](https://boards.straightdope.com/u/Czarcasm)\
**Post date:** [June 13, 2013, 3:07pm UTC](https://boards.straightdope.com/t/board-performance-problems/659491/87 "2013-06-13T15:07:19Z")

</div>

> [@Musicat](#):
>
> Same here, even though all of my subscribed threads have post-06/10 posts. 06/10 seems to be some magic cutoff date. Did the hamsters escape thru a Tom, Dick or Harry tunnel on that date?

I just checked, and the last post on that date happened at 1704 hrs PST. Anyone have a later post on their “6/10” page?

---

<div class="post-metadata">

**Author:** ![Siam\_Sam](https://avatars.discourse-cdn.com/v4/letter/s/d78d45/32.png) [@Siam\_Sam](https://boards.straightdope.com/u/Siam_Sam)\
**Post date:** [June 13, 2013, 3:22pm UTC](https://boards.straightdope.com/t/board-performance-problems/659491/88 "2013-06-13T15:22:14Z")

</div>

> [@Elendil\_s\_Heir](#):
>
> The Quote function still isn’t working. I just tried it with **Musicat** ’s post, just above this one.

It works for me sometimes, not other times. As you can see, it just worked here. But one earlier did not.

---

<div class="post-metadata">

**Author:** ![R3d\_Anonymous](https://avatars.discourse-cdn.com/v4/letter/r/aeb1de/32.png) [@R3d\_Anonymous](https://boards.straightdope.com/u/R3d_Anonymous)\
**Post date:** [June 13, 2013, 6:54pm UTC](https://boards.straightdope.com/t/board-performance-problems/659491/89 "2013-06-13T18:54:48Z")

</div>

You guys might want to check this out if you haven’t already: [http://boards.straightdope.com/sdmb/announcement.php?f=2](http://boards.straightdope.com/sdmb/announcement.php?f=2)

_Finally_, we can hope for a fix.

---

<div class="post-metadata">

**Author:** ![Elendil\_s\_Heir](https://avatars.discourse-cdn.com/v4/letter/e/7cd45c/32.png) [@Elendil\_s\_Heir](https://boards.straightdope.com/u/Elendil_s_Heir)\
**Post date:** [June 13, 2013, 7:23pm UTC](https://boards.straightdope.com/t/board-performance-problems/659491/90 "2013-06-13T19:23:39Z")

</div>

> [@Siam\_Sam](#):
>
> It works for me sometimes, not other times. As you can see, it just worked here. But one earlier did not.

Huh. And it just worked for me, as you see.

Well, thanks, **Anonymous User** , and let’s hope for a longterm fix.

---

<div class="post-metadata">

**Author:** ![Giraffe](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/giraffe/32/129_2.png) [@Giraffe](https://boards.straightdope.com/u/Giraffe)\
**Post date:** [June 13, 2013, 7:42pm UTC](https://boards.straightdope.com/t/board-performance-problems/659491/91 "2013-06-13T19:42:44Z")

</div>

> [@Elendil\_s\_Heir](#):
>
> Huh. And it just worked for me, as you see.

Jerry’s announcement indicates that they’ve replicated the database to slaves. From the symptoms, I think it’s a reasonable hypothesis that one/some of them stopped updating as of June 10th, leading to something like a race condition. When your request goes to an updated database, everything works fine. When it goes to a stuck one, it has no knowledge of posts past June 10th, so it can’t quote posts newer than that or display forum indices properly. Refresh and you may get the updated database or you may get the stuck one again. Totally random from the user perspective.

---

<div class="post-metadata">

**Author:** ![Musicat](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/musicat/32/20189_2.png) [@Musicat](https://boards.straightdope.com/u/Musicat)\
**Post date:** [June 13, 2013, 8:06pm UTC](https://boards.straightdope.com/t/board-performance-problems/659491/92 "2013-06-13T20:06:35Z")

</div>

> [@BigT](#):
>
> I do know that some vBulletin admins say that allowing namechanges causes problems because you have to run this process that updates the entire database. They say that not updating will cause problems along the line. So they won’t allow namechanges under any circumstances. Granted, this is with vBulletin 4.

I am not a SQL expert, but this kind of behavior rings a bell with my considerable experience on other database managers.

Let’s say you want to change the user name on multiple posts. Sounds easy – just traverse all posts for user name X and replace with user name Y.

But if you have a total of a zillion posts for all users, and only a few hundred for user name X, why page thru all zillion when, using an index or pointer file, only a few hundred need be checked?

But there’s a gotcha with this method. If you are using a dynamic index on the user name field, and you change the name for one record, you will then skip to the next record in the newly ordered index, which may not be the next one in the original sequence!

When you finish the process, you may have inadvertently skipped over some records, and you may have screwed up the index as well. I can certainly see how this might lead to problems down the road.

There are solutions, but they can be tricky. Suffice to say an Introduction to Computer 101 programmer probably won’t know how to tackle this without some experience.

---

<div class="post-metadata">

**Author:** ![Czarcasm](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/czarcasm/32/4050_2.png) [@Czarcasm](https://boards.straightdope.com/u/Czarcasm)\
**Post date:** [June 13, 2013, 8:09pm UTC](https://boards.straightdope.com/t/board-performance-problems/659491/93 "2013-06-13T20:09:21Z")

</div>

> [@Siam\_Sam](#):
>
> It works for me sometimes, not other times. As you can see, it just worked here. But one earlier did not.

If the quote doesn’t appear in the reply box, refresh the reply box and it will eventually appear.

---

<div class="post-metadata">

**Author:** ![Musicat](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/musicat/32/20189_2.png) [@Musicat](https://boards.straightdope.com/u/Musicat)\
**Post date:** [June 13, 2013, 8:11pm UTC](https://boards.straightdope.com/t/board-performance-problems/659491/94 "2013-06-13T20:11:31Z")

</div>

> [@Czarcasm](#):
>
> I just checked, and the last post on that date happened at 1704 hrs PST. Anyone have a later post on their “6/10” page?

My latest time is 1756 CST. That would be 1556 PST, right?

And the quote function didn’t work for Czarcasm’s post until the third try.

---

<div class="post-metadata">

**Author:** ![stui\_magpie](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/stui_magpie/32/11010_2.png) [@stui\_magpie](https://boards.straightdope.com/u/stui_magpie)\
**Post date:** [June 14, 2013, 12:40am UTC](https://boards.straightdope.com/t/board-performance-problems/659491/95 "2013-06-14T00:40:19Z")

</div>

I’m not having any login problems, I login automatically when I open the home page, But I am having the problems with quoting and going to a board and seeing no threads in there except the stickies.

---

<div class="post-metadata">

**Author:** ![TubaDiva](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/tubadiva/32/507_2.png) [@TubaDiva](https://boards.straightdope.com/u/TubaDiva)\
**Post date:** [June 14, 2013, 1:20am UTC](https://boards.straightdope.com/t/board-performance-problems/659491/96 "2013-06-14T01:20:44Z")

</div>

Notices of technical problems/issues on this board are all over the board.

Like here:

> **[Scheduled Message Board Maintenance: Starting 1 AM CDT on Friday, June 14th](https://boards.straightdope.com/sdmb/showthread.php?t=693732)**
>
> The message boards are going to be taken down tonight (Friday, June 14th) starting at 1 AM CDT. The master database is going to be taken out of service to be thoroughly checked and possibly repaired. While that is occurring the message board will be...

The board is (temporarily) broken.

Attempts are being made to resolve these issues as quickly as circumstances allow.

---

<div class="post-metadata">

**Author:** ![MsWhatsit](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@MsWhatsit](https://boards.straightdope.com/u/MsWhatsit)\
**Post date:** [June 14, 2013, 1:29am UTC](https://boards.straightdope.com/t/board-performance-problems/659491/97 "2013-06-14T01:29:55Z")

</div>

**Tuba** , I think people are just sharing their experiences because it feels helpful for them to do so. I am not getting the sense from any recent posts in this thread that anyone is harshing on you for not taking action. They are just bug reports. We know you are working on it. It is OK.

---

<div class="post-metadata">

**Author:** ![Trinopus](https://avatars.discourse-cdn.com/v4/letter/t/2bfe46/32.png) [@Trinopus](https://boards.straightdope.com/u/Trinopus)\
**Post date:** [June 14, 2013, 2:26am UTC](https://boards.straightdope.com/t/board-performance-problems/659491/98 "2013-06-14T02:26:01Z")

</div>

GOD DAMN IT! I made a post, and misspelled a word. Edit? Have to log in first. Log in. Edit. Save. “You do not have the right to make changes.” Repeat four times.

Please, please, please, please, fix the problems? Beg & plead and promise to be good!

---

<div class="post-metadata">

**Author:** ![Lamar\_Mundane](https://avatars.discourse-cdn.com/v4/letter/l/85f322/32.png) [@Lamar\_Mundane](https://boards.straightdope.com/u/Lamar_Mundane)\
**Post date:** [June 14, 2013, 2:41am UTC](https://boards.straightdope.com/t/board-performance-problems/659491/99 "2013-06-14T02:41:41Z")

</div>

I don’t think it’s going to make it till 1:00 AM.

She’s breaking up!  
She’s breaking up!

---

<div class="post-metadata">

**Author:** ![voltaire](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/voltaire/32/313_2.png) [@voltaire](https://boards.straightdope.com/u/voltaire)\
**Post date:** [June 14, 2013, 4:21am UTC](https://boards.straightdope.com/t/board-performance-problems/659491/100 "2013-06-14T04:21:25Z")

</div>

I’m certain it’s the “Martin/Zimmerman” thread surpassing the 10k post mark that’s doing it. (Well, not really, but excising that clusterfuck couldn’t hurt, now could it?!) 😃

---

<div class="post-metadata">

**Author:** ![MsWhatsit](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@MsWhatsit](https://boards.straightdope.com/u/MsWhatsit)\
**Post date:** [June 14, 2013, 4:43am UTC](https://boards.straightdope.com/t/board-performance-problems/659491/101 "2013-06-14T04:43:34Z")

</div>

> [@Trinopus](#):
>
> GOD DAMN IT! I made a post, and misspelled a word. Edit? Have to log in first. Log in. Edit. Save. “You do not have the right to make changes.” Repeat four times.
> 
> Please, please, please, please, fix the problems? Beg & plead and promise to be good!

…except for this one.

[Previous page](https://boards.straightdope.com/t/board-performance-problems/659491.md?page=4)

[Next page](https://boards.straightdope.com/t/board-performance-problems/659491.md?page=6)
