|
stymingersfink
Apr 28, 2008, 4:45 AM
Post #1 of 16
(3837 views)
Shortcut
Registered: Aug 12, 2003
Posts: 7250
|
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 28, 2008, 6:13 AM
Post #2 of 16
(3834 views)
Shortcut
Registered: May 21, 2005
Posts: 2304
|
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 15, 2008, 4:01 AM
Post #3 of 16
(3764 views)
Shortcut
Registered: Aug 12, 2003
Posts: 7250
|
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 15, 2008, 5:56 AM
Post #4 of 16
(3763 views)
Shortcut
Registered: May 21, 2005
Posts: 2304
|
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, 5:32 PM
Post #5 of 16
(3745 views)
Shortcut
Registered: Aug 12, 2003
Posts: 7250
|
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 
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.
|
|
|
|
|
ddt
May 17, 2008, 12:40 AM
Post #7 of 16
(3694 views)
Shortcut
Registered: May 21, 2005
Posts: 2304
|
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 17, 2008, 10:00 AM
Post #10 of 16
(3666 views)
Shortcut
Registered: Aug 12, 2003
Posts: 7250
|
sbaclimber wrote: stymingersfink wrote: hopefully there's been found someone who codes better than you. that....I highly doubt...but we'll see  (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)
good luck with that. you'll keep us abreast of you's progress, yea?
|
|
|
|
|
sbaclimber
Jun 1, 2008, 8:09 AM
Post #11 of 16
(3308 views)
Shortcut
Registered: Jan 22, 2004
Posts: 3118
|
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, 8:19 AM
Post #12 of 16
(3304 views)
Shortcut
Registered: Aug 12, 2003
Posts: 7250
|
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.
Nice work! ;)
Wonder how it's gonna be when I'm using the aircard...
|
|
|
|
|
stymingersfink
Jun 1, 2008, 8:22 AM
Post #13 of 16
(3302 views)
Shortcut
Registered: Aug 12, 2003
Posts: 7250
|
...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, 8:25 AM
Post #14 of 16
(3300 views)
Shortcut
Registered: Aug 12, 2003
Posts: 7250
|
I suppose I shouldn't be surprised, really. Tally it up to German (software) engineering.
|
|
|
|
|
sbaclimber
Jun 1, 2008, 8:57 AM
Post #15 of 16
(3296 views)
Shortcut
Registered: Jan 22, 2004
Posts: 3118
|
stymingersfink wrote: I suppose I shouldn't be surprised, really. Tally it up to German (software) engineering.
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, 9:02 AM)
|
|
|
|
|
ddt
Jun 3, 2008, 6:16 AM
Post #16 of 16
(3225 views)
Shortcut
Registered: May 21, 2005
Posts: 2304
|
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
|
|
|
|
|
|
