# Elasped Time Between Searches Increased To 2 Minutes

**URL:** <https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967>\
**Category:** About This Message Board\
**Created:** [April 28, 2007, 6:15pm UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967 "2007-04-28T18:15:49Z")\
**Posts on this page:** 20\
**Page:** 5

<div class="post-metadata">

**Author:** ![Chasing\_Dreams](https://avatars.discourse-cdn.com/v4/letter/c/258eb7/32.png) [@Chasing\_Dreams](https://boards.straightdope.com/u/Chasing_Dreams)\
**Post date:** [May 1, 2007, 4:16am UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/81 "2007-05-01T04:16:54Z")

</div>

[QUOTE=alterego]  
Punish violators of your TOS before you violate paying members.  
[/QUOTE]

I feel violated in the naughty places, lol. 😃

I just tried searching for the SDMB at Dogpile and I found that Windows Live Search contains a listing of some of the threads on the SDMB, see [here](http://search.sympatico.msn.ca/results.aspx?q=site%3Ahttp%3A%2F%2Fboards.straightdope.com&go.x=0&go.y=0&form=QBNO) .

Too bad Windows Live Search can’t find anything relevant. It seems that you only get the listing of SDMB threads when you search for site:[Straight Dope Message Board - Your direct line to thousands of the smartest, hippest people on the planet, plus a few total dipsticks.](http://boards.straightdope.com/sdmb/). Searching for [SDMB Chasing Dreams](http://search.sympatico.msn.ca/results.aspx?q=SDMB+Chasing+Dreams&FORM=MSNH&mkt=en-ca) reveals nothing useful.

---

<div class="post-metadata">

**Author:** ![Rick](https://avatars.discourse-cdn.com/v4/letter/r/9f8e36/32.png) [@Rick](https://boards.straightdope.com/u/Rick)\
**Post date:** [May 1, 2007, 7:16am UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/82 "2007-05-01T07:16:05Z")

</div>

[QUOTE=Stranger On A Train]  
Yeah, I can never remember if Google fired five shots, or six.

Stranger  
[/QUOTE]

So do you feel lucky punk? Well do ya?

---

<div class="post-metadata">

**Author:** ![The\_Librarian](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/the_librarian/32/402_2.png) [@The\_Librarian](https://boards.straightdope.com/u/The_Librarian)\
**Post date:** [May 1, 2007, 11:10am UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/83 "2007-05-01T11:10:07Z")

</div>

**Ed Zotti** ,Thank you for the (if somewhat strange) explanation.

---

<div class="post-metadata">

**Author:** ![Mangetout](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/mangetout/32/19_2.png) [@Mangetout](https://boards.straightdope.com/u/Mangetout)\
**Post date:** [May 1, 2007, 11:25am UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/84 "2007-05-01T11:25:46Z")

</div>

I know of an elegant solution to this problem, but the Quick Reply box is too small to contain it.

---

<div class="post-metadata">

**Author:** ![Sailboat](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/sailboat/32/461_2.png) [@Sailboat](https://boards.straightdope.com/u/Sailboat)\
**Post date:** [May 1, 2007, 12:19pm UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/85 "2007-05-01T12:19:15Z")

</div>

On a board with the mission of fighting ignorance, an easy to use and rapid search function is a fundamental tool _because we should be using it frequently._

On a board whose culture emphasizes not resurrecting old threads but creating links to them, searches are going to be even more frequently used.

Then I read this:

[QUOTE=Ed Zotti]  
No sooner had Jerry gotten the board restored than a single individual proceeded to submit 8 searches in 4 minutes, dropping the board again.  
[/QUOTE]

8 searches in 4 minutes is ridiculous for a human archivist. For that kind of power searching, you’d need a tool…something like a desktop computer, perhaps.

Seriously – 8 searches in 4 minutes by one person _dropped the boards?_ That flabbergasts me. That doesn’t seem like much at all…and we have hundreds of members and deal with hundreds of complex topics every day? What if two people decide to look something up? It just seems inadequate.

Sailboat

---

<div class="post-metadata">

**Author:** ![Squink](https://avatars.discourse-cdn.com/v4/letter/s/b5e925/32.png) [@Squink](https://boards.straightdope.com/u/Squink)\
**Post date:** [May 1, 2007, 1:49pm UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/86 "2007-05-01T13:49:46Z")

</div>

[QUOTE=Sailboat]  
Seriously – 8 searches in 4 minutes by one person _dropped the boards?_ That flabbergasts me.  
[/QUOTE]  
It sounds like vB is keeping the search index on a tape drive, or at best a [mercury delay line](http://ed-thelen.org/comp-hist/vs-univac-mercury-memory.html).

---

<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 1, 2007, 1:50pm UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/87 "2007-05-01T13:50:41Z")

</div>

[QUOTE=Chasing Dreams]  
I just tried searching for the SDMB at Dogpile and I found that Windows Live Search contains a listing of some of the threads on the SDMB, see [here](http://search.sympatico.msn.ca/results.aspx?q=site%3Ahttp%3A%2F%2Fboards.straightdope.com&go.x=0&go.y=0&form=QBNO) .

Too bad Windows Live Search can’t find anything relevant. It seems that you only get the listing of SDMB threads when you search for site:[Straight Dope Message Board - Your direct line to thousands of the smartest, hippest people on the planet, plus a few total dipsticks.](http://boards.straightdope.com/sdmb/). Searching for [SDMB Chasing Dreams](http://search.sympatico.msn.ca/results.aspx?q=SDMB+Chasing+Dreams&FORM=MSNH&mkt=en-ca) reveals nothing useful.  
[/QUOTE]  
We let Google spider the board for a short while a few years back. Community concern and response put an end to that very quickly but Google did pick up quite a few posts in that small amount of time. This is what you’re seeing through Live Search.

---

<div class="post-metadata">

**Author:** ![Ponder\_Stibbons](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/ponder_stibbons/32/343_2.png) [@Ponder\_Stibbons](https://boards.straightdope.com/u/Ponder_Stibbons)\
**Post date:** [May 1, 2007, 1:55pm UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/88 "2007-05-01T13:55:04Z")

</div>

[QUOTE=Sailboat]  
Seriously – 8 searches in 4 minutes by one person _dropped the boards?_ That flabbergasts me. That doesn’t seem like much at all…and we have hundreds of members and deal with hundreds of complex topics every day? What if two people decide to look something up? It just seems inadequate.  
[/QUOTE]  
I am also astounded. This just cannot be right. _Something_ is wrong here. This is not wild-ass conjecture, this is a statement based on my experience with web servers. If the SDMB is the _only thing_ on the server, and the server machine itself is a relatively up-to-date machine (i.e., within the last year or so), there is NO WAY a SMALL NUMBER (8 searches in 4 minutes is _small_, damnit) simple text database searches are going to crash a server. I repeat, _something is wrong_.

Has anyone considered [asking for help?](http://www.vbulletin.com/forum/forumdisplay.php?f=59) I mean, that’s what they’re _there_ for.

---

<div class="post-metadata">

**Author:** ![Gadarene](https://avatars.discourse-cdn.com/v4/letter/g/e47c2d/32.png) [@Gadarene](https://boards.straightdope.com/u/Gadarene)\
**Post date:** [May 1, 2007, 2:06pm UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/89 "2007-05-01T14:06:18Z")

</div>

**Sailboat:**

> [@](#):
>
> On a board with the mission of fighting ignorance, an easy to use and rapid search function is a fundamental tool because we should be using it frequently.
> 
> On a board whose culture emphasizes not resurrecting old threads but creating links to them, searches are going to be even more frequently used.

I could not possibly agree with this more.

---

<div class="post-metadata">

**Author:** ![Joey\_P](https://avatars.discourse-cdn.com/v4/letter/j/919ad9/32.png) [@Joey\_P](https://boards.straightdope.com/u/Joey_P)\
**Post date:** [May 1, 2007, 3:17pm UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/90 "2007-05-01T15:17:29Z")

</div>

[QUOTE=Sailboat]  
What if two people decide to look something up? It just seems inadequate.  
Sailboat  
[/QUOTE]

The servers catch fire and the hamsters burn to death.

Now if _three_ people try to search at the same time, well, the very fabric of the universe will collapse upon itself.  
Never cross the streams.

---

<div class="post-metadata">

**Author:** ![Uncommon\_Sense](https://avatars.discourse-cdn.com/v4/letter/u/f9ae1b/32.png) [@Uncommon\_Sense](https://boards.straightdope.com/u/Uncommon_Sense)\
**Post date:** [May 1, 2007, 4:17pm UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/91 "2007-05-01T16:17:06Z")

</div>

Ooooh, I have a question!

How come after all these years, we’re just learning NOW why the boards crash so frequently? This problem, if it does exist, should have been patched years ago.

Count me as one of the many that find it hard to believe that 8 searches in 4 minutes can cause a meltdown.  
Is there something special about the same person searching 8 times or could 8 different people search once each in the four minute span and cause the same problem? If so, this must happen dozens of times a day.  
This does not seem logical.

---

<div class="post-metadata">

**Author:** ![alterego](https://avatars.discourse-cdn.com/v4/letter/a/6bbea6/32.png) [@alterego](https://boards.straightdope.com/u/alterego)\
**Post date:** [May 1, 2007, 4:23pm UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/92 "2007-05-01T16:23:09Z")

</div>

[QUOTE=Mangetout]  
I know of an elegant solution to this problem, but the Quick Reply box is too small to contain it.  
[/QUOTE]

[Ahem.](http://www.google.com/search?hl=en&rls=com.microsoft%3Aen-US&q=%22this+*+is+too+small+to+contain%22+-margin) :dubious:

---

<div class="post-metadata">

**Author:** ![alterego](https://avatars.discourse-cdn.com/v4/letter/a/6bbea6/32.png) [@alterego](https://boards.straightdope.com/u/alterego)\
**Post date:** [May 1, 2007, 4:30pm UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/93 "2007-05-01T16:30:30Z")

</div>

[QUOTE=TubaDiva]  
We let Google spider the board for a short while a few years back. Community concern and response put an end to that very quickly but Google did pick up quite a few posts in that small amount of time. This is what you’re seeing through Live Search.  
[/QUOTE]

You are referring to [this thread](http://boards.straightdope.com/sdmb/showthread.php?t=336912), no?

Allowing Google to spider the boards was an accident, not a test. To be honest, I can’t believe that you don’t let Google spider the boards. There is such a wealth of information here, and question answering has become such a huge hit on the web (think Yahoo Answers) that this site has tremendous room for monetization and growth. Let Google spider the boards, more people will come in and give you more money for more servers. Create _other_ “perks” for members. I really can’t believe that searching is supposed to be considered a perk in this day and age.

I respect that you guys are very conservative in changing anything here. On the other hand, a bit of creativity and forward thinking applied to the business model could really be good for this place.

---

<div class="post-metadata">

**Author:** ![alterego](https://avatars.discourse-cdn.com/v4/letter/a/6bbea6/32.png) [@alterego](https://boards.straightdope.com/u/alterego)\
**Post date:** [May 1, 2007, 4:36pm UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/94 "2007-05-01T16:36:49Z")

</div>

PS - I would consider not being shown advertisements to be the only perk I need. I have a strong opinion that advertising is brainwashing. Unfortunately I sometimes browse from public computers that I cannot install Adblock on.

So here’s your new business model: Don’t show ads to paying members, and [open the floodgates](http://boards.straightdope.com/robots.txt) to the rest of the Internet.

---

<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:** [May 1, 2007, 4:43pm UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/95 "2007-05-01T16:43:37Z")

</div>

IF vBulletin and/or SQL lock up the ENTIRE database for a search, and IF the search encompasses ALL (or nearly all) records, it might hold everything up for seconds to minutes. i say that from experience with database programming in the broadest sense.

The only excuse I can see for that kind of software is it is easier to write than alternatives; when it was written, databases were smaller and the total locked time very small, so it could be tolerated.

Locking the entire database ensures that no records will be omitted from the search. It prevents new records from being added or old ones edited, which could screw up the results. Under some circumstances, a database that is constantly changing could throw the search into an infinite loop or cause some records to be read more than once.

There are other conditions that cause file and/or record locking, but they are so brief that no one notices. I assume “add a record” is one of these; it is traditional to lock the file before an append so the file length parameters and pointers are updated correctly. But this only takes a relative handful of machine cycles; searching is open-ended and can take much more time.

I’m not saying this is the problem, but if it is, it’s time for vB/SQL to handle the matter more appropriately for current, multi-user, large-file conditions. There are, indeed, better routines available.

Hey, here’s an idea. **Tuba,** could Google’s search engine be applied to our data and vB’s disabled? I’m always impressed by Google’s programming, and maybe we could substitute it and have the added advantage that the board’s index is available externally. Is this possible?

---

<div class="post-metadata">

**Author:** ![Gadarene](https://avatars.discourse-cdn.com/v4/letter/g/e47c2d/32.png) [@Gadarene](https://boards.straightdope.com/u/Gadarene)\
**Post date:** [May 1, 2007, 4:51pm UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/96 "2007-05-01T16:51:56Z")

</div>

> [@](#):
>
> Locking the entire database ensures that no records will be omitted from the search.

And we know this isn’t the case, because the search engine routinely returns incomplete results anyway.

---

<div class="post-metadata">

**Author:** ![Slacker](https://avatars.discourse-cdn.com/v4/letter/s/6bbea6/32.png) [@Slacker](https://boards.straightdope.com/u/Slacker)\
**Post date:** [May 1, 2007, 4:52pm UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/97 "2007-05-01T16:52:39Z")

</div>

[QUOTE=Musicat]  
IF vBulletin and/or SQL lock up the ENTIRE database for a search, and IF the search encompasses ALL (or nearly all) records, it might hold everything up for seconds to minutes.  
[/QUOTE]

It doesn’t.

---

<div class="post-metadata">

**Author:** ![Uncommon\_Sense](https://avatars.discourse-cdn.com/v4/letter/u/f9ae1b/32.png) [@Uncommon\_Sense](https://boards.straightdope.com/u/Uncommon_Sense)\
**Post date:** [May 1, 2007, 5:05pm UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/98 "2007-05-01T17:05:32Z")

</div>

[QUOTE=Slacker]  
It doesn’t.  
[/QUOTE]

Sheesh, if you have some info share it with us. :rolleyes:  
IOW, if you know that it doesn’t then you must know why, right?  
Besides, **Musicat** said **if**.

I like the idea of allowing Google to spider the Dope and archive pages.

Is it possible for that type of Google search by a non-paying member to only offer a tease and then allow paying members to ‘log in’ to get the complete search result?

---

<div class="post-metadata">

**Author:** ![Slacker](https://avatars.discourse-cdn.com/v4/letter/s/6bbea6/32.png) [@Slacker](https://boards.straightdope.com/u/Slacker)\
**Post date:** [May 1, 2007, 5:15pm UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/99 "2007-05-01T17:15:32Z")

</div>

[QUOTE=Uncommon Sense]  
Sheesh, if you have some info share it with us. :rolleyes:  
IOW, if you know that it doesn’t then you must know why, right?  
Besides, **Musicat** said **if**.  
[/QUOTE]

I don’t mean to be so brief, but it just doesn’t work that way. The reason it doesn’t is because the people who wrote vBulletin and MySQL aren’t idiots. Asking me to explain why is like asking someone why cars don’t have square wheels. It just wouldn’t work that way.

As to how it actually does work, I’m not a database expert, so I can’t expound on that adequately, but I know from using and administering vBulletin messageboards since vB debuted years and years ago that it absolutely doesn’t lock the site up when someone is searching. If you need to see for yourself, find a large vBulletin site like [neogaf.com](http://neogaf.com) and try it. Or heck, try it here. Open the SDMB in one window and search for something while clicking around in another. Unless the server is choking in general, it won’t be a problem (I just tried it and it worked fine).

---

<div class="post-metadata">

**Author:** ![Joey\_P](https://avatars.discourse-cdn.com/v4/letter/j/919ad9/32.png) [@Joey\_P](https://boards.straightdope.com/u/Joey_P)\
**Post date:** [May 1, 2007, 5:21pm UTC](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967/100 "2007-05-01T17:21:16Z")

</div>

[QUOTE=alterego]  
Let Google spider the boards, more people will come in and give you more money for more servers. Create _other_ “perks” for members. I really can’t believe that searching is supposed to be considered a perk in this day and age.

[/QUOTE]

Wouldn’t that also allow us to seach the board via google.  
ie from google, you could search  
[search minutes site:boards.straightdope.com] and pull up this thread.

This way we can tax the google servers instead of ours.

[Previous page](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967.md?page=4)

[Next page](https://boards.straightdope.com/t/elasped-time-between-searches-increased-to-2-minutes/401967.md?page=6)
