Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Does deleting msgs cause the forum to get slow?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Does deleting msgs cause the forum to get slow?

 Post Reply Post Reply Page  <12
Author
billd3 View Drop Down
Senior Member
Senior Member


Joined: 19 February 2003
Location: United States
Status: Offline
Points: 530
Post Options Post Options   Thanks (0) Thanks(0)   Quote billd3 Quote  Post ReplyReply Direct Link To This Post Posted: 13 March 2008 at 2:57pm
LOL, we'll be all moved over to you in a couple weeks, Bruce. Limits or not......... that so-called unlimited SQL is great, but constant connection issues and resets of the memory pool are not fine. I'll put up with paying a bit for the space if that means the host can use that money to keep things better.

Besides, with the customer service you folks offer here, not much scares me now. If we have an issue, we simply start a "ticket" and get it dealt with. The other host simply said "sorry, that's your problem".

I run SQL2005 on my home system and IIS and have a duplicate of the forum running to play with settings and appearances, and it's SO nice to have that SQL management right there.

I've deleted a lot of old messages from our current forum based on SQL, on the current/old host, they are no longer relevant, and it did nothing to slow or speed anything. zero impact, other than one of the mods who posts a LOT in that area asked what was up with his post count going down by 50. He said, honest, he's laid off the beer so it wasn't that....
I explained - house-keeping ahead of our move. I move I simply can't wait to happen now!

QUESTION - if the SQL database BACKUP file is 28 meg, what is the actual SQL server database size or space taken on the server??  Just curious.
BillD
http://theamcpages.com
http://theamcforum.com
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: 13 March 2008 at 4:37pm
The size of the database can differer from that of the backup.

However with only a 28Mb database removing content will have no effect on performance. We have forums running on our network with around 400,000 posts and load the same speed as forums with only 100 posts.

Extra SQL Server space with us costs £4.99 per quarter for an extra 100Mb, so it's massively expensive so I wouldn't worry to much about the number of posts in your forum.
Back to Top
 Post Reply Post Reply Page  <12

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.