Welcome Guest
Log In | Register )
You last visited December 9, 2016, 4:13 pm
All times shown are
Eastern Time (GMT-5:00)

Todd, Search Question

Topic closed. 1 reply. Last post 13 years ago by Todd.

Page 1 of 1
PrintE-mailLink

United States
Member #2873
November 25, 2003
1132 Posts
Offline
Posted: March 13, 2004, 10:54 am - IP Logged

I am trying to do a few Message body searches and I get constantly:

Microsoft OLE DB Provider for SQL Server error '80040e31'

Timeout expired

/search.asp, line 143

Is that my system (being too slow), the search to big, or somehting else.

Good Luck!

    Todd's avatar - Cylon 2.gif
    Chief Bottle Washer
    New Jersey
    United States
    Member #1
    May 31, 2000
    23274 Posts
    Offline
    Posted: March 13, 2004, 1:30 pm - IP Logged

    Hey Mike,

    It's not your PC, it's the server.  Although I am running Lottery Post on a dedicated server, it's not enough at this point.  I am currently preparing a massive technology upgrade that will add tons of power to the database engine.  That will fix problems like that timeout.

    I just finished building four new servers that will form the basis of the new setup.  The database server itself is way-out cool, with a 9-disk RAID array, and one hot-spare.  (15,000 RPM Ultra SCSI drives!)  The server also has 8 GB of RAM, so the entire database could theoretically fit into RAM at this point.

    I'm documenting things along the way, so one day I'll publish the upgrade in a nice article.

     

    Check the State Lottery Report Card
    What grade did your lottery earn?

     

    Sign the Petition for True Lottery Drawings
    Help eliminate computerized drawings!