So why can’t I post here?
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: General Discussion
Forum Description: General discussion and chat on any topic.
URL: https://forums.webwiz.net/forum_posts.asp?TID=12488
Printed Date: 01 April 2026 at 5:14pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: So why can’t I post here?
Posted By: arpee
Subject: So why can’t I post here?
Date Posted: 10 November 2004 at 1:11pm
|
I posted a message yesterday and it said it had to be approved by a moderator. How long does it take to post here????? How can it stay current if people have to wait days for their posts to show? |
Replies:
Posted By: dj air
Date Posted: 10 November 2004 at 2:15pm
|
your post has been approved or deleted as its not waiting to be done. it can take a up to a day roughly, but allow 72 hours. i was on here about 10 times today. so it must have been done before today/ when i came online. |
Posted By: arpee
Date Posted: 11 November 2004 at 11:17am
|
I guess they don't appreciate my comments about the code. I posted that I found why the forum was running slow for people. There are several nested loops that could easily be converted to getrows for a very noticable increase in performance. The main page went from 7 seconds to under 1 second to load Also, if you change the wfSpAuthorDesc sproc by adding "TOP 1" after "SELECT", you will avoid having to query all authors just to get one. Another performance tweak.
|
Posted By: michael
Date Posted: 11 November 2004 at 1:16pm
|
arpee, the moderators and the owner to their best to approve posts as soon as possible. Your post would be best suited for the suggestion forum which IIRC is not moderated.
The support forums are moderated now as there were too many non-relevant, repetitive and bogus posts in forums that should only be used for support questions. I am sure borg appreciates your suggestions so please don't be discouraged if it takes some time for it to show. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: MadDog
Date Posted: 11 November 2004 at 1:55pm
What loops are you talking about? ------------- http://www.iportalx.net" rel="nofollow"> 
|
arpee wrote:Posted By: michael
Date Posted: 11 November 2004 at 3:22pm
|
I think he is talking about For loops recordset iteration. Loading certain recordsets into an array without "looping" does increase performance. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: WebWiz-Bruce
Date Posted: 11 November 2004 at 3:50pm
|
I do plan on re-writing the default.asp page for th next version to improve performance as well as a number of other pages. The problem with changing the wfSpAuthorDesc to include TOP 1 after 'SELECT' is that your forum statistics will never show more than '1' as the total number of registered users. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: arpee
Date Posted: 11 November 2004 at 5:12pm
|
I just realized that, scratch my comment on that, although I am considering a faster query for that. Here is the gist of what the default page does...
strSQL = "EXECUTE GetAllForumCategories" Do While NOT rsGetAllForumCategories.EOF 'DISPLAY CATEGORY TITLE strSQL = "EXECUTE GetForumsWhereCatIs @intCatID = " & intCatID Do While NOT rsGetForumsWhereCatIs.EOF 'DISPLAY FORUM TITLE W/LINK strSQL = "EXECUTE GetModerators @intForumID = " & intForumID Do While NOT rsGetModerators.EOF 'DISPLAY MODERATORS rsGetModerators.MoveNext loop 'FOR NEXT MODERATOR strSQL = "EXECUTE GetLastPostInfo @intForumID = " & intForumID 'DISPLAY LAST POST INFO rsGetForumsWhereCatIs.MoveNext loop 'FOR NEXT FORUM rsGetAllForumCategories.MoveNext loop 'FOR NEXT CATEGORY
That is quite a few nested queries that should be changed to getrows so that each recordset can be closed immediately. I pretty significant performance boost |
Posted By: arpee
Date Posted: 11 November 2004 at 5:28pm
|
If anyone wants to know how to do getrows, simply replace:
with this:
That will close that recordset immediately. Then you will need to change:
and replace with:
Now, at the bottom where you see:
Loop Replace with just:
That's pretty much it, do that to all your loops and you will see big change in speed |