Forums: Rockclimbing.com: Suggestions & Feedback:
question about page loading
RSS FeedRSS Feeds for Suggestions & Feedback

Premier Sponsor:

 


stymingersfink


Apr 27, 2008, 9:45 PM
Post #1 of 16 (3266 views)
Shortcut

Registered: Aug 12, 2003
Posts: 7250

question about page loading
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

why, when i click on "my topics" does the "watched threads" load almost immediately, but the list of threads I've posted to take forever to load?

it doesn't seem to matter if greasemonkey is turned on or off... is it something on the server side?


ddt


Apr 27, 2008, 11:13 PM
Post #2 of 16 (3263 views)
Shortcut

Registered: May 20, 2005
Posts: 2304

Re: [stymingersfink] question about page loading [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

Yes, it's on the server side. Both queries are executed using ajax, so they return their result asynchronously and display as soon as the result is ready. The "My Topics" query is way more complex than the "Watched Threads" query, so it loads much slower.

DDT


stymingersfink


May 14, 2008, 9:01 PM
Post #3 of 16 (3193 views)
Shortcut

Registered: Aug 12, 2003
Posts: 7250

Re: [ddt] question about page loading [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

are there ways to speed it up? like maybe only load the last hundred threads replied to?

IDK... I really don't care about the threads replied to with no answers three years ago. What's been said, been's said.

sometimes the wait is nearly interminable, especially when I'm roaming on an air-card. I'm not sure if i've dropped signal or what. how would you go about relieving the server of the load?


ddt


May 14, 2008, 10:56 PM
Post #4 of 16 (3192 views)
Shortcut

Registered: May 20, 2005
Posts: 2304

Re: [stymingersfink] question about page loading [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

We only load the threads to be displayed on a particular page. The trick is to get the right set out of a (potentially) much larger number, based on the particular page being selected by the user.

Having said that, I am pretty sure my SQL code is far from optimal and some performance tweaking may be possible. If someone out there has an interest, PM me and I'll share the query code for you to review and make suggestions.

DDT


stymingersfink


May 15, 2008, 10:32 AM
Post #5 of 16 (3174 views)
Shortcut

Registered: Aug 12, 2003
Posts: 7250

Re: [ddt] question about page loading [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

ddt wrote:
We only load the threads to be displayed on a particular page. The trick is to get the right set out of a (potentially) much larger number, based on the particular page being selected by the user.

Having said that, I am pretty sure my SQL code is far from optimal and some performance tweaking may be possible. If someone out there has an interest, PM me and I'll share the query code for you to review and make suggestions.

DDT
Unfortunately my code "skills" don't extend much beyond this here editor.Crazy

Just a curiosity question here, but did you write the code, or purchase it pre-fab? 'Cause if you wrote it GU, props are definitely in order.Smile


ddt


May 16, 2008, 5:39 PM
Post #6 of 16 (3125 views)
Shortcut

Registered: May 20, 2005
Posts: 2304

Re: [stymingersfink] question about page loading [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

stymingersfink wrote:
Just a curiosity question here, but did you write the code, or purchase it pre-fab? 'Cause if you wrote it GU, props are definitely in order.Smile

This specific functionality (My Topics) was coded from scratch by me... hence the poor performance! Wink

DDT


ddt


May 16, 2008, 5:40 PM
Post #7 of 16 (3123 views)
Shortcut

Registered: May 20, 2005
Posts: 2304

Re: [stymingersfink] question about page loading [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

 
BTW, I did get an offer from someone to review the code, so we'll see of we can improve things a bit.


stymingersfink


May 16, 2008, 10:37 PM
Post #8 of 16 (3112 views)
Shortcut

Registered: Aug 12, 2003
Posts: 7250

Re: [ddt] question about page loading [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

ddt wrote:
BTW, I did get an offer from someone to review the code, so we'll see of we can improve things a bit.
good up on them!


hopefully there's been found someone who codes better than you. No offense, of course... I'm sure you know what I mean...Smile


sbaclimber


May 17, 2008, 12:48 AM
Post #9 of 16 (3105 views)
Shortcut

Registered: Jan 21, 2004
Posts: 3071

Re: [stymingersfink] question about page loading [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

stymingersfink wrote:
hopefully there's been found someone who codes better than you.
that....I highly doubt...but we'll seeTongue

(from my experience, it isn't who's "better", just having someone else with a slightly different way of looking at things can help immensely)


(This post was edited by sbaclimber on May 17, 2008, 12:50 AM)


stymingersfink


May 17, 2008, 3:00 AM
Post #10 of 16 (3095 views)
Shortcut

Registered: Aug 12, 2003
Posts: 7250

Re: [sbaclimber] question about page loading [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

sbaclimber wrote:
stymingersfink wrote:
hopefully there's been found someone who codes better than you.
that....I highly doubt...but we'll seeTongue

(from my experience, it isn't who's "better", just having someone else with a slightly different way of looking at things can help immensely)
yes, perspective is often under-rated.

good luck with that. you'll keep us abreast of you's progress, yea? Smile


sbaclimber


Jun 1, 2008, 1:09 AM
Post #11 of 16 (2737 views)
Shortcut

Registered: Jan 21, 2004
Posts: 3071

Re: [stymingersfink] question about page loading [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

Any improvement, Symi?
I sent through a probable solution about a week and a half ago, but don't know if DDT has had a chance to implement it yet.


stymingersfink


Jun 1, 2008, 1:19 AM
Post #12 of 16 (2733 views)
Shortcut

Registered: Aug 12, 2003
Posts: 7250

Re: [sbaclimber] question about page loading [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

sbaclimber wrote:
Any improvement, Symi?
I sent through a probable solution about a week and a half ago, but don't know if DDT has had a chance to implement it yet.
well, now that you mention it, it's loading about a thousand times faster than it used to. On both computers. Hadn't noticed it moving faster till you mentioned it, but I'm pretty sure it wasn't this fast yesterday.

Nice work! ;)


Wonder how it's gonna be when I'm using the aircard...


stymingersfink


Jun 1, 2008, 1:22 AM
Post #13 of 16 (2731 views)
Shortcut

Registered: Aug 12, 2003
Posts: 7250

Re: [stymingersfink] question about page loading [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

...and it would seem that all the pages load faster now, even when viewed at 100post/page with those long, involved, heavily quoted and often rambling topics.

SCHWEET!


stymingersfink


Jun 1, 2008, 1:25 AM
Post #14 of 16 (2729 views)
Shortcut

Registered: Aug 12, 2003
Posts: 7250

Re: [stymingersfink] question about page loading [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

I suppose I shouldn't be surprised, really. Tally it up to German (software) engineering.Smile


sbaclimber


Jun 1, 2008, 1:57 AM
Post #15 of 16 (2725 views)
Shortcut

Registered: Jan 21, 2004
Posts: 3071

Re: [stymingersfink] question about page loading [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

stymingersfink wrote:
I suppose I shouldn't be surprised, really. Tally it up to German (software) engineering.Smile
Must be the water here Tongue
I won't take credit for anything just yet, we'll have to wait and see what DDT says he's done. I didn't suggest much of anything specific, just a general direction in which to look.

BTW, if it had anything to do with my suggested solution, it wouldn't be software engineering, rather database administration.
And, seeing as it was server-side, there should be a noticeable difference when using your aircard as well.


(This post was edited by sbaclimber on Jun 1, 2008, 2:02 AM)


ddt


Jun 2, 2008, 11:16 PM
Post #16 of 16 (2654 views)
Shortcut

Registered: May 20, 2005
Posts: 2304

Re: [sbaclimber] question about page loading [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

Glad it's going better. We've made some changes, specifically cleaned up some scripts that tied the majority of pages down. I have not implemented sbaclimber's suggestions yet - thanks very much for it, by the way. I was out the past week on vacation. Will let you know...

DDT


Forums : Rockclimbing.com : Suggestions & Feedback

 


Search for (options)

Log In:

Username:
Password: Remember me:

Go Register
Go Lost Password?
$10.89 (10% off)
$12.56 (10% off)
$62.96 (10% off)
$80.06 (10% off)



Follow us on Twiter Become a Fan on Facebook