Performance Bug Fixed

   / Performance Bug Fixed #1  

Muhammad

Administrator
Moderator
Joined
Mar 21, 1998
Messages
20,626
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

(INOP) CATERPILLAR TL943 TELESCOPIC FORKLIFT (A50459)
(INOP) CATERPILLAR...
UNUSED U Bolt Wire Rope Clamp Set (A50860)
UNUSED U Bolt Wire...
2008 Honda Civic Sedan (A48082)
2008 Honda Civic...
100 GALLON PORTABLE DSL TANK (A50460)
100 GALLON...
2002 Stewart and Stevenson Services M1088A1 Military Truck (A48836)
2002 Stewart and...
2019 CATERPILLAR 304E2 CR EXCAVATOR (A50458)
2019 CATERPILLAR...
 
Top