Performance Bug Fixed

   / Performance Bug Fixed #1  

Muhammad

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

2022 Club Car Tempo Golf Cart (A48082)
2022 Club Car...
Cherokee 10ft S/A Enclosed Cargo Trailer (A48082)
Cherokee 10ft S/A...
2016 John Deere TS Gator Utility Cart (A49346)
2016 John Deere TS...
2022 Club Car Tempo Golf Cart (A48082)
2022 Club Car...
2015 Hyundai Elantra Sedan (A48082)
2015 Hyundai...
2018 Dodge Ram 5500 Bucket Truck - 4x4, Versalift VST40, 45FT Reach, Dakota Line Body (A50397)
2018 Dodge Ram...
 
Top