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."
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] )
__________________ The Diesel Stop FAQ Editor
"I'm Not Dead."
- Old Guy, Monty Python and The Holy Grail
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
__________________ 1996 F-350 XLT CC SRW 4x4 with plenty o' Redneck Bling: APCM●BTS-E4OD●4L10●MADDOG injectors●Hypermax H2E, intercooler, & exhaust●TYMAR intake & HPX●TSM disc brakes●Hydro-Boost●International water pump●215 amp generator●CCV re-route●285/75R16 Wild Country XTX tires●Centramatics●Denon DCR-830RD & DCH-520 203,000 happy miles DZLJIM 3:16 ~~NTxPSA - Hold my beer and watch this.~~
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.
</font><blockquote><font class="small">In reply to:</font><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!
2008 F250 Crew Cab 4x4 SRW Short Bed Lariat 6.4L / 5 Speed Auto
2005 F350 Crew Cab 4x4 DRW Long Bed Lariat 6.0L / 5 Speed Auto (SOLD)
2005 F350 Crew Cab 4x4 DRW Long Bed Lariat 6.0L / 5 Speed Auto (SOLD)
2003 F250 Crew Cab 4x4 SRW Short Bed XLT Sport Package 6.0L PSD / 5 Speed Auto (SOLD)
2002 F350 Crew Cab 4x2 DRW Long Bed XLT PSD 4R100 (SOLD)
2001 F250 Crew Cab 4X4 SRW Short Bed Lariat PSD 4R100 (SOLD)
2000 F250 Crew Cab 4X4 SRW Short Bed Lariat PSD 4R100 (SOLD)
1999 F350 Super Cab 4x2 DRW Long Bed XLT PSD 4R100 (SOLD)
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.
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.
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
__________________ The Diesel Stop FAQ Editor
"I'm Not Dead."
- Old Guy, Monty Python and The Holy Grail
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.
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]
__________________
My Sierra Blanca is a '99.5 PSD CrewCab hot-rod Towing Machine! BTS tranny; TurboRamAir intake and 4" stainless turbo-back exhaust; DP-Tuner tunes flashed into an Edge Evolution tuner; ISSPRO EV gauges and TTM; AIC; SP-Diesel exhaust brake and torque converter controller. I special-ordered it new and plan to drive it until it quits.
Linear Mode
