Site News News and updates about the site.

Website Database Work

Thread Tools
 
Search this Thread
 
Old Oct 27, 2004 | 11:44 AM
  #1  
jthorpe's Avatar
Thread Starter
DTR Founder
20 Year Member
Liked
Loved
Community Favorite
 
Joined: May 2002
Posts: 4,930
Likes: 14
From: Raleigh, NC
Website Database Work

I'm sure you all have noticed that we've been experiencing some growing pains over the last couple of weeks. Our forum is getting too big for the hardware that we have, so until that hardware is in place, I've made some minor changes:

1. You can do searches every 60 seconds instead of every 15.
2. Searches will not be allowed when the server reaches a certain load limit. This is automatic. When the load goes down, searches will be allowed again
3. You can only post every 60 seconds.
4. Attachments are now disabled permanently. They take up HUGE amounts of space. You'll have to post pictures via your web host from now on. You'll see other attachments disappear over time. There are too many to delete all at once without leave the site down for an entire day.
5. Disabled the last post function in the user profile view. You would never think it, but those queries were looking through huge amounts of data and causing slowdowns.

I've also made some other minor changes that might allow a speed increase but only time will tell if they worked. The search function is what's killing us at night, so limiting that during high load should help us avoid the "Server Too Busy" error.

Thanks for your patience.
Reply
Old Oct 27, 2004 | 05:56 PM
  #2  
DPG's Avatar
DPG
Registered User
 
Joined: Feb 2002
Posts: 728
Likes: 0
From: Western Michigan
Hey Jack!

Thanks for trying to stay on top of things for us! I am not surprised about the changes, I have been getting that pesky "Server Too Busy" window frequently in the evening.

DeWain
Reply
Old Oct 27, 2004 | 05:58 PM
  #3  
jthorpe's Avatar
Thread Starter
DTR Founder
20 Year Member
Liked
Loved
Community Favorite
 
Joined: May 2002
Posts: 4,930
Likes: 14
From: Raleigh, NC
Thanks DeWain,

Well, tonight will be a good test of my changes. The search engine will stop working automatically when the server load gets to a certain number, which will hopefully cut down on the server busy messages. So far it seems much more snappy today. Give it another 2 hours, and we'll really know whether it worked or not.
Reply
Old Oct 27, 2004 | 08:31 PM
  #4  
12PACK's Avatar
Registered User
 
Joined: Nov 2002
Posts: 822
Likes: 0
From: Central MA
Jack, how about asking everyone to clean up their Private Message folders, both Inbox and Sent. Can't hurt, right?
Reply
Old Oct 27, 2004 | 09:36 PM
  #5  
jthorpe's Avatar
Thread Starter
DTR Founder
20 Year Member
Liked
Loved
Community Favorite
 
Joined: May 2002
Posts: 4,930
Likes: 14
From: Raleigh, NC
Originally posted by Gypsyman
So we will no longer be able to post pictures on here? Am I reading this correctly?
You can as long as you have it hosted somewhere, and you link to it. You will not be able to attach pictures to threads.
Reply
Old Oct 27, 2004 | 09:38 PM
  #6  
phox_mulder's Avatar
Administrator
 
Joined: May 2002
Posts: 6,522
Likes: 4
From: Sandy, Utah
Originally posted by Jack Thorpe
You can as long as you have it hosted somewhere, and you link to it. You will not be able to attach pictures to threads.
Can you still link to pics in our album here?


phox
Reply
Old Oct 27, 2004 | 09:44 PM
  #7  
Gypsyman's Avatar
Registered User
 
Joined: May 2003
Posts: 830
Likes: 0
From: Spokane, Wa
Jack,

I'm assuming that cleaning up our personal readers rigs section will help. Yes?

Richard
Reply
Old Oct 27, 2004 | 09:45 PM
  #8  
jthorpe's Avatar
Thread Starter
DTR Founder
20 Year Member
Liked
Loved
Community Favorite
 
Joined: May 2002
Posts: 4,930
Likes: 14
From: Raleigh, NC
Originally posted by Gypsyman
Jack,

I'm assuming that cleaning up our personal readers rigs section will help. Yes?

Richard
It's not going to help the attachment issue, no. You can link to pictures there, but you will not be able to attach pictures directly in the forum. The forum and reader's rigs are two different databases.
Reply
Old Oct 27, 2004 | 10:58 PM
  #9  
AggieJustin's Avatar
Registered User
 
Joined: Jul 2002
Posts: 2,242
Likes: 16
From: Celina, TX
Since the search engine will shut down when you reach your load threshold, will this also take out the View New Posts feature? Or does this search get an exception?

EDIT: Never mind....my question just got answered. Server went busy right after I posted and I couldn't do a View New Posts when it came back.
Reply
Old Oct 28, 2004 | 08:36 AM
  #10  
jthorpe's Avatar
Thread Starter
DTR Founder
20 Year Member
Liked
Loved
Community Favorite
 
Joined: May 2002
Posts: 4,930
Likes: 14
From: Raleigh, NC
exactly
Reply
Old Nov 3, 2004 | 08:29 AM
  #11  
RowJ's Avatar
Registered User
 
Joined: Apr 2004
Posts: 8,234
Likes: 1
From: Texas/Oklahoma Border
Jack

Know it must be a big job keeping everything running smoothly.

I'm one of the lucky ones...on line mostly day time!

Just hope we don't have to go the same direction as the other Dodge Web Page. Fancy update...pretty new pages...takes FOREVER to open anything if your stuck with a dial up modem!

RJ
Reply
Old Nov 3, 2004 | 08:51 AM
  #12  
jthorpe's Avatar
Thread Starter
DTR Founder
20 Year Member
Liked
Loved
Community Favorite
 
Joined: May 2002
Posts: 4,930
Likes: 14
From: Raleigh, NC
oh don't worry, we'll have pretty new pages soon, but they won't be slow. I'm not big into Java menus either.
Reply
Old Nov 3, 2004 | 05:35 PM
  #13  
joefarmer's Avatar
Registered User
 
Joined: Sep 2003
Posts: 1,300
Likes: 0
From: stupid ohio
As far as the search engine, I've found that google can help offset that load. I normally search via google and it seems to pickup the archive correctly. For example, searching for "block heater site:dieseltruckresource.com" yields a selection of forum post lists with the words 'block heater' in the title.

Just a thought,
brandon.
Reply
Old Nov 16, 2004 | 12:41 AM
  #14  
westcoaster's Avatar
Registered User
20 Year Member
 
Joined: Oct 2002
Posts: 476
Likes: 33
Hmmm.... didn't you just go through this about 6 months ago?? I thought you bought a pile of new hardware. Is that all "trash" now?
Reply
Old Nov 16, 2004 | 06:48 AM
  #15  
jthorpe's Avatar
Thread Starter
DTR Founder
20 Year Member
Liked
Loved
Community Favorite
 
Joined: May 2002
Posts: 4,930
Likes: 14
From: Raleigh, NC
I bought one server, and that was almost 2 years ago, and about 10,000 members ago. The server is not "trash", but it IS underpowered.
Reply



All times are GMT -5. The time now is 01:35 AM.