Web Wiz Forums - Batch delete members

Print Page | Close Window

Batch delete members

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

Topic: Batch delete members

Posted By: TippTeam
Subject: Batch delete members
Date Posted: 12 March 2014 at 8:26pm

Hi Bruce, Hi WebWiz Team

Using a very old 9.55 Version. Just on my way to buy the newest one premium. But before upgrade i tried to delete old things ...

Trying to use the batch delete member tool. About 70'000 users to delete i think. I am always running in a server timeout (asp).

On IIS i changed already to 2000 second time out. Any idea? Maybe a change in a script setting the time out with Server.ScriptTimeout manually? Which file i have to make this change?

Or you have a stored procedure i can use?

thank you very much for your support and the great work
TippTeam

Replies:

Posted By: WebWiz-Bruce
Date Posted: 13 March 2014 at 9:41am

The batch delete tool has to do allot of work and deleting 70,000 members would take many hours.

The only solution would be to keep running the tool or just leave those members in the database.

-------------
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: TippTeam
Date Posted: 13 March 2014 at 9:52am

Sure this is my false. Better do this on a regulary base.

Anyway - thanks for the feedback. Do you have a clue if this is working in the newer forum version faster? So i upgrade first and then delete? (Hardware is not a problem - Really HighEnd Servers)

Will keep you UpToDate.

Posted By: TippTeam
Date Posted: 13 March 2014 at 11:37am

Hi Bruce

I walked an other way. I am sorry, but took a look in the code of the admin_batch_delete_members.asp .

And for each table who is connected in this batch process i used an SQL statement like this:

delete from dbo.xxxxThread where Author_ID in

(

SELECT xxxxAuthor.Author_ID FROM WWF9Author

WHERE (xxxxAuthor.Join_date < GetDate() - 720 AND xxxxAuthor.No_of_posts = 0) AND xxxxAuthor.Author_ID > 2

)

In 15min everything was done. 14min i used to understand, write the code and test. Maybe its an good idea to use in the next version something like this. Hint: instead of the "IN"-Statement in the SQL above you can also use an "inner join". Maybe this is even more better SQL way.

best regards and thx for the good work