Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Slow count
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Slow count
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
Mattblack View Drop Down
Groupie
Groupie
Avatar

Joined: 21 January 2003
Location: United Kingdom
Status: Offline
Points: 139 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mattblack Quote  Post ReplyReply Direct Link To This Post Topic: Slow count
    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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Mattblack View Drop Down
Groupie
Groupie
Avatar

Joined: 21 January 2003
Location: United Kingdom
Status: Offline
Points: 139 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mattblack Quote  Post ReplyReply Direct Link To This Post 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

 
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.