Performance Bug Fixed

   / Performance Bug Fixed #1  

Muhammad

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

2025 KJ K4525 UNUSED Double Garage Metal Shed (A47484)
2025 KJ K4525...
2019 Bobcat T740 Compact Track Loader Skid Steer (A44571)
2019 Bobcat T740...
2024 BCL Fabrication Landscape Dump Trailer - Heavy-Duty Utility Trailer for Mulch Debris Hauling (A46877)
2024 BCL...
2017 Isuzu NPR HD Crew Cab Landscape Dump Truck (A44571)
2017 Isuzu NPR HD...
New Lewis Brothers MFG DB2 Poultry Housekeeper (A46877)
New Lewis Brothers...
2025 Dig Master DM100 UNUSED Mini Excavator (A47484)
2025 Dig Master...
 
Top