Slow count
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=12268
Printed Date: 11 April 2026 at 10:08am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Slow count
Posted By: Mattblack
Subject: Slow count
Date Posted: 21 October 2004 at 11:37am
|
Hope someone can help with this.... I have 18000 posts on my site now after deleting old topics. The default.asp page counts all the posts in each forum. This is incredibly slow, i think this is because it is access. Can anyone provide a solution? SQL Server is not an option im affraid. And i dont have access to the IIS servers config. Hopefully someone knows how to speed it up without removing the "Posts" column. Cheers Matt |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 21 October 2004 at 1:56pm
|
Try removing the number of forums you have in total. The post count on the default.asp page will not slow things, but the number of forums you have listed will. ------------- 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: dpyers
Date Posted: 21 October 2004 at 3:33pm
|
Usually after deleting a bunch of things, it's usefull to do a compact and restore on an access db. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: Mattblack
Date Posted: 23 October 2004 at 4:39am
|
removing the number of forums? u mean like merging 2 into 1 and so on? Not really possible, theyre all needed. If i delete a load of posts from the database as a test, it speeds it up making it instant. Borg can u elaborate on the removing number of forums. Cheers guys
|
Posted By: WebWiz-Bruce
Date Posted: 23 October 2004 at 2:19pm
|
It sounds like the server you are on doesn't have enough resorces to cope with larger Access databases. Try compacting and repairing the database as a temporary option to speed things up, but I thinks it's time you either moved to MS SQL Server or found another web host that allows more server resources for your site. ------------- 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 |