Web Wiz Forums - problem with batch delete topics

Print Page | Close Window

problem with batch delete topics

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=30778
Printed Date: 30 March 2026 at 11:31pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: problem with batch delete topics

Posted By: alexli
Subject: problem with batch delete topics
Date Posted: 19 June 2013 at 6:33am

my forum is 10 years old and it has 700,000 posts and the database(MS-SQL) is 1.4GB now. I am starting to batch delete topics to save space and improve speed. But whenever I delete over 10,000 posts, it gets timeout error. Is there another way to get around it?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 19 June 2013 at 10:50am

Deleting this many posts will always place allot of strain on the server. You would need to delete in smaller batches.

You also need to use SQL Server Management Studio to shrink your database once you have finished deleting posts so that the database size is truncated.

-------------
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