# OK, you gots the money

**URL:** <https://boards.straightdope.com/t/ok-you-gots-the-money/244599>\
**Category:** About This Message Board\
**Created:** [May 11, 2004, 9:55am UTC](https://boards.straightdope.com/t/ok-you-gots-the-money/244599 "2004-05-11T09:55:53Z")\
**Posts on this page:** 9\
**Page:** 2

<div class="post-metadata">

**Author:** ![Mister\_Rik](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/mister_rik/32/491_2.png) [@Mister\_Rik](https://boards.straightdope.com/u/Mister_Rik)\
**Post date:** [May 23, 2004, 7:19pm UTC](https://boards.straightdope.com/t/ok-you-gots-the-money/244599/21 "2004-05-23T19:19:49Z")

</div>

I’ve heard in mentioned a few times that _searching_ is a big part of the speed problem. I wonder if it would be possible to set up two servers, with one dedicated to handling searches and one simply handling normal posting. That way searches wouldn’t bog down the primary server.

Of course, I don’t know if this is technically feasible or not. But I picture the “search server” holding a mirror of the board, perhaps one day behind the primary server (I suspect most searches are not conducted for material posted the same day, as the current day’s discussions are going to be located on the front page of each forum). So clicking the “Search” link could automatically transfer the searcher over to the second server.

It’s an idea, anyway.

---

<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:** [May 23, 2004, 10:09pm UTC](https://boards.straightdope.com/t/ok-you-gots-the-money/244599/22 "2004-05-23T22:09:03Z")

</div>

I vaguely recall this being discussed before, but I do not remember the outcome. Just a guess on my part, but I would suspect the vB software made this difficult or impossible to even contemplate.

I’ll inquire and see if I can get some information from a more knowledgeable source.

your humble TubaDiva  
Administrator

---

<div class="post-metadata">

**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:** [May 23, 2004, 10:47pm UTC](https://boards.straightdope.com/t/ok-you-gots-the-money/244599/23 "2004-05-23T22:47:29Z")

</div>

I think that what happens then, is that the mirroring process is even more of a pain in the gluteus than the searches were in the first place. Then again, it’s conceivable that this could somehow be worked into the daily backup…

---

<div class="post-metadata">

**Author:** ![rowrrbazzle](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/rowrrbazzle/32/414_2.png) [@rowrrbazzle](https://boards.straightdope.com/u/rowrrbazzle)\
**Post date:** [May 24, 2004, 11:52pm UTC](https://boards.straightdope.com/t/ok-you-gots-the-money/244599/24 "2004-05-24T23:52:37Z")

</div>

My understanding was that people would have to pay or the SDMB would go away.

[post=4800777]Here’s what Ed said:[/post]

> [@](#):
>
> **What does a subscription get me?**
> 
> [ul][li]Posting privileges for one year.[/li][li]The title under your name says “charter member.”[/li][li]Post count (i.e., number of messages you’ve posted to date appears with your username)[/li][li]Ability to search the massive SDMB message database[/li][li]Ability to view member profiles[/li][li]Biographical info included with each post (optional)[/li][li]Other cool stuff that we throw in later, possibly including private messaging, SDMB calendar, custom signatures, and “who’s online” feature. (This list edited by EZ 3/19/04.)[/ul] …[/li] **Do subscriptions mean the board will run faster?**
> 
> ```auto
> 
> We make no promises,
> 
> ```
> 
> but we’re hopeful. The board ran reasonably well after our server upgrade in November 2002, when we had 3,500 current members - that is, people who had posted within the last 30 days. Shortly before switching to subscriptions we had 7,000 current members and the board ran slowly - OK, it crawled - during peak times. The practical capacity of the board, i.e., the largest number to whom we can provide decent service, is somewhere between those two figures. Our initial subscription drive attracted 3,800 users, more than we expected, and traffic hasn’t declined noticeably.

No guarantee of improved performance.

\<aside\>In the post, there’s also this: “Little Ed gets paid, believe it or not.” Why would Ed author a post and then refer to himself in the third person? Could Ed really be Cecil? (And don’t bother editing the post. I have screen captures and I saved the page. 😃 ) \</aside\>

---

<div class="post-metadata">

**Author:** ![iamme99](https://avatars.discourse-cdn.com/v4/letter/i/57b2e6/32.png) [@iamme99](https://boards.straightdope.com/u/iamme99)\
**Post date:** [May 25, 2004, 2:23am UTC](https://boards.straightdope.com/t/ok-you-gots-the-money/244599/25 "2004-05-25T02:23:34Z")

</div>

Well, performance has been pretty good the last few days! I hope this keeps up. I’d also like the 1 hour daily maintenance outage at 3:30am Central time get reduced and or eliminated.

---

<div class="post-metadata">

**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:** [May 25, 2004, 3:06pm UTC](https://boards.straightdope.com/t/ok-you-gots-the-money/244599/26 "2004-05-25T15:06:08Z")

</div>

> [@](#):
>
> I’d also like the 1 hour daily maintenance outage at 3:30am Central time get reduced and or eliminated.

Trust me, you _wouldn’t_ like for that to be eliminated. Mostly, that time is used for the daily backup, and every so often, things happen. Without that backup, a single glitch could spell the end of the board. With that backup, generally the worst that can happen is that we lose one day’s worth of posts.

---

<div class="post-metadata">

**Author:** ![iamme99](https://avatars.discourse-cdn.com/v4/letter/i/57b2e6/32.png) [@iamme99](https://boards.straightdope.com/u/iamme99)\
**Post date:** [May 26, 2004, 12:20am UTC](https://boards.straightdope.com/t/ok-you-gots-the-money/244599/27 "2004-05-26T00:20:11Z")

</div>

> [@Chronos](#):
>
> Trust me, you _wouldn’t_ like for that to be eliminated. Mostly, that time is used for the daily backup, and every so often, things happen. Without that backup, a single glitch could spell the end of the board. With that backup, generally the worst that can happen is that we lose one day’s worth of posts.

But can’t the backup time be reduced? Or why can’t you do the backup live? On my WinXP system I do backups live using the Shadow Copy service which allows an open file to be backed up.

---

<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:** [May 26, 2004, 1:53pm UTC](https://boards.straightdope.com/t/ok-you-gots-the-money/244599/28 "2004-05-26T13:53:16Z")

</div>

You cannot compare a home user system with Windows XP to a server running a message board for thousands of users, that’s apples and oranges!

Here’s what Jerry the Tech God says on the situation and mirroring search:

[[ I’m sure it’s technically feasible but it’s not something I’m capable of devoting resources to at this time. Increasing search performance by mirroring the MySQL databases and/or adding additional search servers would only exacerbate the bandwidth problems we are already having.

While I’m sure people are wondering what they are getting for their subscription the answer is they are getting the continued existence of the board. Improved board performance was not supposed to be promised as a result of subscriptions. It may have been speculated upon but to the best of my knowledge it was not promised when we devised the subscription plan.

What we did promise was the continued existence of the board in the general state it had existed prior to the implementation of the subscription plan. We are and will continue to deliver on that promise. ]]

your humble TubaDiva  
Administrator

---

<div class="post-metadata">

**Author:** ![iamme99](https://avatars.discourse-cdn.com/v4/letter/i/57b2e6/32.png) [@iamme99](https://boards.straightdope.com/u/iamme99)\
**Post date:** [May 27, 2004, 1:36am UTC](https://boards.straightdope.com/t/ok-you-gots-the-money/244599/29 "2004-05-27T01:36:00Z")

</div>

> [@TubaDiva](#):
>
> You cannot compare a home user system with Windows XP to a server running a message board for thousands of users, that’s apples and oranges!
> 
> Here’s what Jerry the Tech God says on the situation and mirroring search:
> 
> [[ I’m sure it’s technically feasible but it’s not something I’m capable of devoting resources to at this time. Increasing search performance by mirroring the MySQL databases and/or adding additional search servers would only exacerbate the bandwidth problems we are already having.
> 
> While I’m sure people are wondering what they are getting for their subscription the answer is they are getting the continued existence of the board. Improved board performance was not supposed to be promised as a result of subscriptions. It may have been speculated upon but to the best of my knowledge it was not promised when we devised the subscription plan.
> 
> What we did promise was the continued existence of the board in the general state it had existed prior to the implementation of the subscription plan. We are and will continue to deliver on that promise. ]]
> 
> your humble TubaDiva  
> Administrator

Regardless of home vs. business, what I am talking about is concepts. It’s just a matter of scale. Of course, it also depends on what software you are running.

I don’t know if this has been addressed sometime in the past, but I’d be willing to wager that there are a good number of people with heavy duty tech expertise here who might be willing to volunteer to help out. Has TPTB every put out a call for volunteer help, seeing the “Jerry, the tech god” has too much other work to do?

[Previous page](https://boards.straightdope.com/t/ok-you-gots-the-money/244599.md?page=1)
