# Question / possible answer for why SD is so slow **URL:** \ **Category:** About This Message Board\ **Created:** [October 17, 2003, 1:50am UTC](https://boards.straightdope.com/t/question-possible-answer-for-why-sd-is-so-slow/207912 "2003-10-17T01:50:39Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Ryle\_Dup](https://avatars.discourse-cdn.com/v4/letter/r/5f9b8f/32.png) [@Ryle\_Dup](https://boards.straightdope.com/u/Ryle_Dup)\ **Post date:** [October 17, 2003, 1:50am UTC](https://boards.straightdope.com/t/question-possible-answer-for-why-sd-is-so-slow/207912/1 "2003-10-17T01:50:39Z")
I’ve recently set up 2 vBulletin forums, and I just noticed this option in the adminCP. “Showing the last post on a member profile can cause large table scans which leads to table locking. This may increase load time on your fourms as well as the load of your server. This option should only be enabled for smaller boards.” Since the SD has this enabled, wouldn’t that explain a lot of hamster deaths? Just curious if this has much effect on SD, and if so, shouldn’t it be disabled? ---
**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:** [October 17, 2003, 12:38pm UTC](https://boards.straightdope.com/t/question-possible-answer-for-why-sd-is-so-slow/207912/2 "2003-10-17T12:38:30Z")
This is not an option in the current version of vB we have installed, 2.2.8. your humble TubaDiva Administrator ---
**Author:** ![John\_Carter\_of\_Mars](https://avatars.discourse-cdn.com/v4/letter/j/2bfe46/32.png) [@John\_Carter\_of\_Mars](https://boards.straightdope.com/u/John_Carter_of_Mars)\ **Post date:** [October 20, 2003, 2:09am UTC](https://boards.straightdope.com/t/question-possible-answer-for-why-sd-is-so-slow/207912/3 "2003-10-20T02:09:15Z")
Bonnie: Financial factors are at play here. This message board does not produce income for the Chicago reader. It’s here as a courtesy. The SDMB is FREE. Anybody that wants to speed the board up should limit their searches to only _essential_ ones. This should be less than one per month. I think if that were done, the hamPsters could boogie right along. ---
**Author:** ![Una\_Persson](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/una_persson/32/346_2.png) [@Una\_Persson](https://boards.straightdope.com/u/Una_Persson)\ **Post date:** [October 20, 2003, 12:33pm UTC](https://boards.straightdope.com/t/question-possible-answer-for-why-sd-is-so-slow/207912/4 "2003-10-20T12:33:02Z")
Another thing too is that some people in the vBulletin Board owners community are a wee bit suspicious of the extremely overdue and very problematic version 3.x, and wish to wait for a bit before dedicating the IT resources to giving it a shot. I know I won’t be upgrading to 3.x for some time, maybe never - I may switch to a different software rather than upgrade, in fact. ---
**Author:** ![Chronos](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/chronos/32/134_2.png) [@Chronos](https://boards.straightdope.com/u/Chronos)\ **Post date:** [October 21, 2003, 1:15am UTC](https://boards.straightdope.com/t/question-possible-answer-for-why-sd-is-so-slow/207912/5 "2003-10-21T01:15:09Z")
> [@](#): > > This is not an option in the current version of vB we have installed, 2.2.8. I take it you mean that _disabling_ it is not an option? Because “Last post” is right there in the profiles. Still, though, one would presume that this is only an issue when folks are viewing profiles, and I can’t see that that would be one of the more commonly-used features. ---
**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:** [October 21, 2003, 12:37pm UTC](https://boards.straightdope.com/t/question-possible-answer-for-why-sd-is-so-slow/207912/6 "2003-10-21T12:37:47Z")
It’s not an administrative option you can toggle on and off or select in version 2.2.8, that’s what I meant. Of course, you can custom tailor vB through coding to make it do damn near anything you want, but it’s Chicago Reader policy not to go too far afield with coding changes. I have passed this suggestion over to Jerry, however; might not be a bad idea. your humble TubaDiva Administrator ---
**Author:** ![handy](https://avatars.discourse-cdn.com/v4/letter/h/b5a626/32.png) [@handy](https://boards.straightdope.com/u/handy)\ **Post date:** [October 21, 2003, 2:54pm UTC](https://boards.straightdope.com/t/question-possible-answer-for-why-sd-is-so-slow/207912/7 "2003-10-21T14:54:18Z")
“Still, though, one would presume that this is only an issue when folks are viewing profiles…” I thought about that too. Another thing people could do is turn off ‘view all sigs’ in their profile. That way the board doesn’t have to create all those sigs for each user on each page I look at. ---
**Author:** ![Beastal](https://avatars.discourse-cdn.com/v4/letter/b/a183cd/32.png) [@Beastal](https://boards.straightdope.com/u/Beastal)\ **Post date:** [October 21, 2003, 6:17pm UTC](https://boards.straightdope.com/t/question-possible-answer-for-why-sd-is-so-slow/207912/8 "2003-10-21T18:17:58Z")
Maybe if we got rid of handy > [@](#): > > Posts: 17162 … the boards would speed up quite nicely. ---
**Author:** ![Ryle\_Dup](https://avatars.discourse-cdn.com/v4/letter/r/5f9b8f/32.png) [@Ryle\_Dup](https://boards.straightdope.com/u/Ryle_Dup)\ **Post date:** [October 21, 2003, 8:30pm UTC](https://boards.straightdope.com/t/question-possible-answer-for-why-sd-is-so-slow/207912/9 "2003-10-21T20:30:46Z")
> [@](#): > > \*Originally posted by Chronos \* > \*\*I take it you mean that _disabling_ it is not an option? Because “Last post” is right there in the profiles. > > Still, though, one would presume that this is only an issue when folks are viewing profiles, and I can’t see that that would be one of the more commonly-used features. \*\* Actually, the tables build themselves weither or not you check them, so this means every time someone posts, their profile has to rebuild to update itself. It sure does _sound_ like that could be an enormous strain on the server. ---
**Author:** ![UncleBeer](https://avatars.discourse-cdn.com/v4/letter/u/977dab/32.png) [@UncleBeer](https://boards.straightdope.com/u/UncleBeer)\ **Post date:** [October 21, 2003, 10:33pm UTC](https://boards.straightdope.com/t/question-possible-answer-for-why-sd-is-so-slow/207912/10 "2003-10-21T22:33:10Z")
**Moderator’s Notes:** Beastal, if you have a problem with another member here, take it to the Pit. This ain’t the place. And ya know, if people refrain from inappropriate posts in inappropriate forums, the boards might also speed up nicely. Consider yourself warned. ---
**Author:** ![Beastal](https://avatars.discourse-cdn.com/v4/letter/b/a183cd/32.png) [@Beastal](https://boards.straightdope.com/u/Beastal)\ **Post date:** [October 22, 2003, 10:52am UTC](https://boards.straightdope.com/t/question-possible-answer-for-why-sd-is-so-slow/207912/11 "2003-10-22T10:52:28Z")
> [@](#): > > \*Originally posted by UncleBeer \* > \*\ ***Moderator’s Notes:** > Beastal, if you have a problem with another member here, take it to the Pit. This ain’t the place. And ya know, if people refrain from inappropriate posts in inappropriate forums, the boards might also speed up nicely. Consider yourself warned. \*\* Uhm, [Dude.](http://dictionary.reference.com/search?q=sarcasm) ---
**Author:** ![UncleBeer](https://avatars.discourse-cdn.com/v4/letter/u/977dab/32.png) [@UncleBeer](https://boards.straightdope.com/u/UncleBeer)\ **Post date:** [October 22, 2003, 12:32pm UTC](https://boards.straightdope.com/t/question-possible-answer-for-why-sd-is-so-slow/207912/12 "2003-10-22T12:32:12Z")
Uhm, dude yourseslf. The thing is, we see an awful lot of posts bitching about handy’s post total. How are we to know which are sarcastic and which are earnest? ---
**Author:** ![Beastal](https://avatars.discourse-cdn.com/v4/letter/b/a183cd/32.png) [@Beastal](https://boards.straightdope.com/u/Beastal)\ **Post date:** [October 22, 2003, 2:01pm UTC](https://boards.straightdope.com/t/question-possible-answer-for-why-sd-is-so-slow/207912/13 "2003-10-22T14:01:20Z")
Fair enough, I didn’t know that. I guess I could have included a smiley at the end of my post, to remove any doubt. No ill feelings I hope.