Performance Bug Fixed

   / Performance Bug Fixed #1  

Muhammad

Administrator
Moderator
Joined
Mar 21, 1998
Messages
20,622
Location
San Diego, CA
Tractor
None currently
We have fixed a bug in the forum databases that was causing some hang-ups. We've tested and now see much better response times throughout the forum. I'm sorry for any inconvenience during the slow-downs, but hopefully we're back up to speed now.

msig.gif
 
   / Performance Bug Fixed #2  
Muhammad...

Hurray, it's faster, better, new & improved!/w3tcompact/icons/smile.gif/w3tcompact/icons/smile.gif

Thank you & we owe you a lunch...

...and what part of New York are you in?

18-35197-JD5205JFMsignaturelogo.JPG
 
   / Performance Bug Fixed #3  
It does seem to be working quite well now. Thanks again, Muhammad.

Bird
 
   / Performance Bug Fixed
  • Thread Starter
#4  
<font color=blue>...and what part of New York are you in?</font color=blue>

Near Binghamton... for now.

msig.gif
 
   / Performance Bug Fixed #6  
Hmmm.....

No sooner do yopu say that, and I start noticing that it's slower /w3tcompact/icons/shocked.gif!!

The initial response is pretty quick, but (as an example) when I display the "Forum Home", there is quite a pause between each section. Seems like the server is getting stressed. Would this number of users be an issue Muhammad?

I did check on the users that are online, and see that there are 15 registered, and 16 unregistered.

The GlueGuy
 
   / Performance Bug Fixed
  • Thread Starter
#7  
I too see the slight pause between the categories... again, the script is making calls to the databases to return those results... we're still looking into some database issues.

We have a few more tricks to try yet. /w3tcompact/icons/wink.gif

msig.gif
 
   / Performance Bug Fixed #8  
Muhammad- First off, thanks for building and maintaining this site. It's a great resource. Secondly, it sounds like we could be neighbors. Hope to meet up with you someday. In fact it seems like there's quite a few members from upstate NY.

Lastly, just FYI, I've recently had issues with screen sizes. The forum home page is always the right size but SOMETIMES when I go to a current thread the resolution appears to be one level higher than the 800x600 I use on my PC. Speed seems kind of slow in the mid afternoon but I suspect that's when you get the heaviest traffic. FWIW, my browser is Netscape 4.7.

Thanks Again- Dave
 
   / Performance Bug Fixed
  • Thread Starter
#9  
Next time the page is too wide, let me know... and I'll check it. Usually when I see a thread widened by a long URL or wide image, I edit the message to fit the formatting.

msig.gif
 
   / Performance Bug Fixed #10  
<font color=blue>the script is making calls to the databases to return those results</font color=blue>

If you're doing dynamic SQL, then that could be a performance issue. We've found that pre-compiling the queries and substituting arguments to be about 5-10 times faster in many circumstances. Don't know anything about your platform or other stuff, but thought I would throw that in /w3tcompact/icons/smile.gif

The GlueGuy
 

Tractor & Equipment Auctions

2017 Ditch Witch FX30 Vacuum Excavator System T/A Trailer (A45336)
2017 Ditch Witch...
2017 Mack GU713 Granite Tri-Axle Dump Truck (A46683)
2017 Mack GU713...
NEW Wolverine 3PT Hitch Receiver (A48289)
NEW Wolverine 3PT...
Mack Model R Truck (A47369)
Mack Model R Truck...
New Wolverine 72'' Skid Steer Brush Mower (A48289)
New Wolverine 72''...
2017 Kubota M5660SU-D 4WD Utility Tractor (A46683)
2017 Kubota...
 
Top