| Author |
 Topic  |
|
dreamr_3
Starting Member
7 Posts |
 Posted - 16 May 2002 : 16:50:38
|
Is there anyone with a HEAVILY loaded Snitz site (and quite a few non-member viewers) running v3.3.03 who would like to speed up their forums? I have an interest in writing non-member view pages that look exactly like the canned ones, but rely on only a few database queries instead of 30 to 40... After non-member pages I could turn my attention to re-written member pages optimized for the fewest database hits... But in theory if ALL non-members start using a fraction of the processing power previously required that will leave more power to support the real users...
Not sure I ever plan on running Snitz myself, but if I were to write this code it would be nice to have someone with a high use site lined up to test it and provide feedback... any takers?
Josh
Wed Developer
www.indtech.edu
|
|
|
dreamr_3
Starting Member
7 Posts |
Posted - 16 May 2002 : 16:52:44
|
Those of you with Access would be prime candidates as that is what I have available to code against... Though once it was working well I wouldn't mind getting it up and running for the other databases...
|
 |
|
|
Aaron S.
Average Member
USA
985 Posts |
Posted - 16 May 2002 : 17:00:17
|
I would be interested.
I have been doing some minor rewrites, but have no time to get into anything major.
My forum is slow... it uses SQL Server, but still drags.
--Aaron
DOWNLOAD GREAT NEW MODS HERE |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 16 May 2002 : 17:29:43
|
This is exactly what we have been working on in v3.4. Reducing the database calls, trying to speed up the pages.
Here is a comparison for the default.asp page load times in v3.3.03 and v3.4:
v3.3.03 (logged in as an admin): 7.30 seconds
v3.3.03 (not logged in): 4.34 seconds
v3.4 (logged in as an admin): 2.13 seconds
v3.4 (not logged in): 1.16 seconds
comparison on forum.asp viewing the Help: General / Current Version forum (25 topics per page)
v3.3.03 (logged in as an admin): 3.88 seconds
v3.3.03 (not logged in): 3.42 seconds
v3.4 (logged in as an admin): 1.14 seconds
v3.4 (not logged in): 0.46 seconds |
|
|
|
VodkaFish
Average Member
USA
654 Posts |
Posted - 16 May 2002 : 17:45:21
|
Richard, those numbers are very impressive. They calm me down with the wait that is 3.4  Seriously, very good show.
v ø d k â f ï § h |
|
|
|
@tomic
Senior Member
USA
1790 Posts |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 16 May 2002 : 19:05:54
|
Good work 
How many calls on average for those pages ?
www.daoc-halo.com |
|
|
|
dreamr_3
Starting Member
7 Posts |
Posted - 16 May 2002 : 19:39:50
|
I'm new to Snitz, but I've been doing web development (ASP, Oracle, MS SQL, etc) for several years. Here's how I see the first page query wise... (when no one is logged in)
One query with a left join to the users table can get the ENTIRE category and forum list...
If moderators are to be shown they could be left joined in as well to avoid a seperate query... OR you could stick the forum ID's in a table, then query for ALL moderators in one statement instead of one per forum...
This complicates the code a tad (one recordset using group bys), but the database access payoff is great... again, that's one or two queries for the largest portion of the page...
The board statistics can be cached for x amount of time (15 sec, 30, 1 minute, etc) I already had that code working earlier... This would save time on highly active boards because I think there are some slower queries burried in that section...
Hope this all makes sense, again my experience is with the concepts in genernal, not Snitz... I just tossed a database library I'd written into snitz the other day and made all the SQL statements go through it so I could get a list so I have some idea of what the current version is doing.
It does sound like v3.4 will improve upon many of the speed concerns... just wondering if you all are still leaning towards looping through one query to execute another each time or if these would be optimized by joins and group bys? Or can that not be done because the code must stay "database independent" to a large degree?
Josh
|
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 16 May 2002 : 19:54:57
|
Without putting words into the Dev's mouths, I suspect you will find that they have got the calls to the DB down to a very low number.
I played around myself with the 3.3.03 code and even on my rather heavily modded forum, no page has more than around 8 calls to the database. If I took the Mods out it would probably be 2, 3 worst case.
30 forums logged in as admin and my default.asp takes on average 0.2 seconds to create, my forum showing 25 topics per page around 0.08-0.1, and the real kicker was active topics, you can now display the last months worth of topics without any time outs, again creation is around 0.2 seconds (and thats for 300-400 topics displaying)
Now all I need is a host who can serve the data up as fast as I create it
www.daoc-halo.com |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 16 May 2002 : 20:06:36
|
| do you have moderation and subscriptions turned on? |
|
|
|
dreamr_3
Starting Member
7 Posts |
Posted - 16 May 2002 : 21:27:59
|
I have both features turned on in my test system... I understand these add extra queries, but when a user isn't even logged in those queries really aren't needed. That's just what I was going to eliminate with my planned mod... (ie, get everything with one query or two) I have like 3 forums and there were around 43 individual calls to the database... I just want to offer an alternate to those still using 3.3 until 3.4 is available :-)
Josh
|
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 16 May 2002 : 21:58:55
|
quote:
do you have moderation and subscriptions turned on?
No both of them have been removed completely from my code (not just turned off), so an unfair comparison really.
www.daoc-halo.com |
|
|
|
Fury
New Member
USA
62 Posts |
Posted - 24 May 2002 : 22:18:18
|
Any estimates on when 3.4 will be available? I was getting ready to attempt something similar (although I am certain 3.4 will be better than whatever I come up with). So if it's going to be available relatively soon I'll hold off. Or if you are looking for a test subject for the new code ...
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
|
Cassius
Starting Member
United Kingdom
17 Posts |
Posted - 30 May 2002 : 10:13:28
|
If you want to try and make the forum faster, maybe try using the SQL Shape Command 2.1 sequence in the sQL statements, this is great for speeding up SQL.
Thats if your good at Shape of course,
Shape reduces the SQL Statement by half, speeds up the reliability and also, reduces the risk of mistakes in code, missing out " and all that.
life a blast, don't use the fuel to much |
|
|
|
ROB
Junior Member
USA
347 Posts |
Posted - 30 May 2002 : 10:51:10
|
quote:
If you want to try and make the forum faster, maybe try using the SQL Shape Command 2.1 sequence in the sQL statements, this is great for speeding up SQL.
Thats if your good at Shape of course,
Shape reduces the SQL Statement by half, speeds up the reliability and also, reduces the risk of mistakes in code, missing out " and all that.
I've never even heard of the "Shape" command... Sounds pretty cool though. Any idea where I can get a good overview?
Jeff Hester :: BigBlueBall.com - Everything about instant messaging
 |
|
|
|
Topic |
|
Topic Locked
Nathan Bales