Performance Bug Fixed

[Muhammad]

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.

 

[Anonymous Poster]

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?

 

[Bird]

It does seem to be working quite well now. Thanks again, Muhammad.

Bird

 

[Muhammad]

<font color=blue>...and what part of New York are you in?</font color=blue>

Near Binghamton... for now.

 

[scruffy]

Muhammad, it's all working fine! Except for this thread, of course...... ;o)
Thanks!

 

[GlueGuy]

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

 

[Muhammad]

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

 

[DaveM]

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

 

[Muhammad]

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.

 

[GlueGuy]

<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

 

[DaveM]

OK. This page seems to be consistantly too wide. This is also a test for me to see if I can rename a link for you. look here

Dave

 

[Muhammad]

Ok. There was a link that IE splits onto two lines, but Netscape doesn't... so I made it a direct link... fixed now.

 

[DaveM]

Hi Muhammad- Here's another wide page here

Dave

 

[scruffy]

Muhammad, J.D.Owning/850 Doesn't Start is a wee bit too wide! I think maybe the posts of the manuals pages blew it. It was fine yesterday.