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
Topic Options
Post Options
Thanks(0)
Sure this is my false. Better do this on a regulary base.