Web Wiz Support and Community Forums : Slow count https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 10:12:25 +0000 Sat, 23 Oct 2004 14:19:03 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=12268 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Slow count : It sounds like the server you...]]> https://forums.webwiz.net/slow-count_topic12268_post68125.html#68125 Author: WebWiz-Bruce
Subject: 12268
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 tospeed things up, but I thinks it's time you either moved to MS SQLServer or found another web host that allows more server resources foryour site.
]]> Sat, 23 Oct 2004 14:19:03 +0000 https://forums.webwiz.net/slow-count_topic12268_post68125.html#68125 <![CDATA[Slow count : removing the number of forums?...]]> https://forums.webwiz.net/slow-count_topic12268_post68104.html#68104 Author: Mattblack
Subject: 12268
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

 

]]> Sat, 23 Oct 2004 04:39:45 +0000 https://forums.webwiz.net/slow-count_topic12268_post68104.html#68104 <![CDATA[Slow count : Usually after deleting a bunch...]]> https://forums.webwiz.net/slow-count_topic12268_post68031.html#68031 Author: dpyers
Subject: 12268
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.]]> Thu, 21 Oct 2004 15:33:08 +0000 https://forums.webwiz.net/slow-count_topic12268_post68031.html#68031 <![CDATA[Slow count : Try removing the number of forums...]]> https://forums.webwiz.net/slow-count_topic12268_post68005.html#68005 Author: WebWiz-Bruce
Subject: 12268
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.
]]> Thu, 21 Oct 2004 13:56:52 +0000 https://forums.webwiz.net/slow-count_topic12268_post68005.html#68005 <![CDATA[Slow count : Hope someone can help with this.... I...]]> https://forums.webwiz.net/slow-count_topic12268_post67982.html#67982 Author: Mattblack
Subject: 12268
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

]]> Thu, 21 Oct 2004 11:37:21 +0000 https://forums.webwiz.net/slow-count_topic12268_post67982.html#67982