Website Database Work
#1
DTR Founder
Thread Starter
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.
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.
#2
Registered User
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
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
#3
DTR Founder
Thread Starter
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.
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.
#5
DTR Founder
Thread Starter
Originally posted by Gypsyman
So we will no longer be able to post pictures on here? Am I reading this correctly?
So we will no longer be able to post pictures on here? Am I reading this correctly?
#6
Administrator
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.
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.
phox
Trending Topics
#8
DTR Founder
Thread Starter
Originally posted by Gypsyman
Jack,
I'm assuming that cleaning up our personal readers rigs section will help. Yes?
Richard
Jack,
I'm assuming that cleaning up our personal readers rigs section will help. Yes?
Richard
#9
Registered User
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.
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.
#11
Registered User
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
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
#13
Registered User
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.
Just a thought,
brandon.