Site News News and updates about the site.

Website Database Work

Old 10-27-2004, 11:44 AM
  #1  
DTR Founder
Thread Starter
 
jthorpe's Avatar
 
Join Date: May 2002
Location: Raleigh, NC
Posts: 4,930
Received 14 Likes on 11 Posts
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.
Old 10-27-2004, 05:56 PM
  #2  
DPG
Registered User
 
DPG's Avatar
 
Join Date: Feb 2002
Location: Western Michigan
Posts: 728
Likes: 0
Received 0 Likes on 0 Posts
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
Old 10-27-2004, 05:58 PM
  #3  
DTR Founder
Thread Starter
 
jthorpe's Avatar
 
Join Date: May 2002
Location: Raleigh, NC
Posts: 4,930
Received 14 Likes on 11 Posts
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.
Old 10-27-2004, 08:31 PM
  #4  
Registered User
 
12PACK's Avatar
 
Join Date: Nov 2002
Location: Central MA
Posts: 822
Likes: 0
Received 0 Likes on 0 Posts
Jack, how about asking everyone to clean up their Private Message folders, both Inbox and Sent. Can't hurt, right?
Old 10-27-2004, 09:36 PM
  #5  
DTR Founder
Thread Starter
 
jthorpe's Avatar
 
Join Date: May 2002
Location: Raleigh, NC
Posts: 4,930
Received 14 Likes on 11 Posts
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.
Old 10-27-2004, 09:38 PM
  #6  
Administrator
 
phox_mulder's Avatar
 
Join Date: May 2002
Location: Sandy, Utah
Posts: 6,522
Likes: 0
Received 1 Like on 1 Post
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
Old 10-27-2004, 09:44 PM
  #7  
Registered User
 
Gypsyman's Avatar
 
Join Date: May 2003
Location: Spokane, Wa
Posts: 830
Likes: 0
Received 0 Likes on 0 Posts
Jack,

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

Richard
Old 10-27-2004, 09:45 PM
  #8  
DTR Founder
Thread Starter
 
jthorpe's Avatar
 
Join Date: May 2002
Location: Raleigh, NC
Posts: 4,930
Received 14 Likes on 11 Posts
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.
Old 10-27-2004, 10:58 PM
  #9  
Registered User
 
AggieJustin's Avatar
 
Join Date: Jul 2002
Location: Celina, TX
Posts: 2,242
Received 16 Likes on 13 Posts
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.
Old 10-28-2004, 08:36 AM
  #10  
DTR Founder
Thread Starter
 
jthorpe's Avatar
 
Join Date: May 2002
Location: Raleigh, NC
Posts: 4,930
Received 14 Likes on 11 Posts
exactly
Old 11-03-2004, 08:29 AM
  #11  
Registered User
 
RowJ's Avatar
 
Join Date: Apr 2004
Location: Texas/Oklahoma Border
Posts: 8,234
Likes: 0
Received 1 Like on 1 Post
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
Old 11-03-2004, 08:51 AM
  #12  
DTR Founder
Thread Starter
 
jthorpe's Avatar
 
Join Date: May 2002
Location: Raleigh, NC
Posts: 4,930
Received 14 Likes on 11 Posts
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.
Old 11-03-2004, 05:35 PM
  #13  
Registered User
 
joefarmer's Avatar
 
Join Date: Sep 2003
Location: stupid ohio
Posts: 1,300
Likes: 0
Received 0 Likes on 0 Posts
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.
Old 11-16-2004, 12:41 AM
  #14  
Registered User
 
westcoaster's Avatar
 
Join Date: Oct 2002
Location: Surrey, B.C.
Posts: 473
Received 32 Likes on 27 Posts
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?
Old 11-16-2004, 06:48 AM
  #15  
DTR Founder
Thread Starter
 
jthorpe's Avatar
 
Join Date: May 2002
Location: Raleigh, NC
Posts: 4,930
Received 14 Likes on 11 Posts
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.

Thread Tools
Search this Thread
Quick Reply: Website Database Work



All times are GMT -5. The time now is 09:52 AM.