Speed Differences? - Diesel Forum

JLester · 10-16-2002, 04:50 PM

I just finished upgrading the network speed between the web and database servers. If you are still getting slow page load times, please post the info shown at the bottom of the page like this for example: "Generated in 0.048 seconds in which 0.005 seconds were spent on a total of 5 queries."

Thanks,
Jason

Shawn · 10-16-2002, 04:52 PM

I just had a 3 1/2 second response time with the usual 3 second on the queries.

SP

Shawn · 10-16-2002, 04:53 PM

Ugh... in posting the last response:

Generated in 16.679 seconds in which 16.459 seconds were spent on a total of 17 queries. Zlib compression disabled.

(Posting this response: Generated in 0.052 seconds in which 0.006 seconds were spent on a total of 7 queries. I think I need to stop now. I am getting into a recursive loop [img]/ubbthreads/images/graemlins/wink.gif[/img] )

DaveBey · 10-16-2002, 04:59 PM

Jason -- Is there a threshold for a "slow" time? Don't want to say something is slow when it's normal. [img]/ubbthreads/images/graemlins/crazy.gif[/img] [img]/ubbthreads/images/graemlins/tongue.gif[/img]

Cheers from Tulsa, OK! [img]/ubbthreads/images/graemlins/smile.gif[/img]
Dave

DaveBey · 10-16-2002, 05:02 PM

Gotcha beat! [img]/ubbthreads/images/graemlins/grin.gif[/img] [img]/ubbthreads/images/graemlins/grin.gif[/img]

Generated in 35.013 seconds in which 34.923 seconds were spent on a total of 12 queries. Zlib compression disabled.

Got that when I tried to view the Events and Rallies Forum just now.

Cheers from Tulsa, OK! [img]/ubbthreads/images/graemlins/smile.gif[/img]
Dave

mhardin · 10-16-2002, 05:03 PM

Going from the main index to the other forum:
Generated in 18.743 seconds in which 13.755 seconds were spent on a total of 33 queries. Zlib compression disabled.

Loading this reply box:
Generated in 9.399 seconds in which 8.459 seconds were spent on a total of 6 queries. Zlib compression disabled.

JLester · 10-16-2002, 05:11 PM

That's definitely too slow still. I'm going to have to look into other options.

Jason

**BWilliams** · 10-16-2002, 05:12 PM

<blockquote>In reply to:<hr />
I just finished upgrading the network speed between the web and database servers. If you are still getting slow page load times, please post the info shown at the bottom of the page like this for example: "Generated in 0.048 seconds in which 0.005 seconds were spent on a total of 5 queries."

Thanks,
Jason

[/ QUOTE ]
Jason,

Normally I don't notice the site speed because we have a T3 line at the dealership. I'm out of the office this week working the RVIA show with Fontaine and am using dial-up. The connection here is ONLY 26.4, I am going crazy! I tried a few days ago to browse the forum and just gave up because it was so slow. Today it seems to be doing great, even with the 26.4 connection!

Thanks [img]/ubbthreads/images/graemlins/wink.gif[/img]

JLester · 10-16-2002, 06:00 PM

I've been watching the queries with a special program and see that there are a couple of specific queries that are taking several seconds to run. In the meantime, other queries queue up until the slower one finishes. Many of the slowest queries are users searching all forums for keywords. With nearly 900,000 posts, that can take a while to return the results. I've disabled searching all forums temporarily to see if that helps any.

Jason

caveman · 10-16-2002, 06:05 PM

Searching the entire database? Holly smokes. Can you reach out and slap hands?

JLester · 10-16-2002, 06:19 PM

Since making that change, I haven't seen a single query take over 3 seconds. Before the change, we were averaging a query taking over 15 seconds or more every couple of minutes. Might be on the right track now.

Jason

Shawn · 10-16-2002, 06:29 PM

Wait a sec, I remember somewhere I read about MySQL not liking querying across multiple tables (Does the search do that?) or not liking something or other about multiple something. Let me go find that link again.

SP

caveman · 10-16-2002, 06:38 PM

Not sure about MySQL. SQL on the system I manage takes for ever if you're searhing mulitple tables. It does work though, hit the key and take a coffee break. Is MySQL much different, it's SQL afterall?
Could be.

**SmokeyWren** · 10-16-2002, 07:05 PM

<blockquote>In reply to:<hr />
I've disabled searching all forums temporarily to see if that helps any.

[/ QUOTE ] See my post at click here.

That ability to search only the '99-up forums is something I've been needing for a long time. I was going to suggest you add it, but then when I went to be sure it wasn't already there - it was! [img]/ubbthreads/images/graemlins/blush.gif[/img]

Shawn · 10-16-2002, 07:23 PM

Been doing quite a few reloads for about 15 minutes now. No spikes [img]/ubbthreads/images/graemlins/wink.gif[/img]

Still cannot find the link though. What ya did *seems* to fix it which is a good thing.

SP