Time-out when deleting folders

[MichaelRyom]

Hi

 

I'm trying to delete a folder with nested objects - password lists. But it times out with the following error msg in error console.

 

Is there anything the can be done to change the time-out timer? Passwordstate and mssql express is installed on the same server.

 

02/06/2018 19:53:18	General Error	Error Code = Thread was being aborted., StackTrace = at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at Passwordstate.Common.AddDebugInfoData(String Category, String DebugInformation, String EventType) at Passwordstate.PasswordList.DeletePasswordList(Int32 intPasswordListID, String strPasswordList) at Passwordstate.PasswordList.DeleteFolderAndAllNestedItems(Int32 PasswordListID)	Error
02/06/2018 19:53:18	General Error	Error Code = Query timeout expired, StackTrace = at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Passwordstate.PasswordList.DeletePasswordList(Int32 intPasswordListID, String strPasswordList)	Error

[support]

Hi Michael,
 

This issue is a timeout with your SQL Server, and in the .NET Framework the default is set to 30 seconds for database connections. We're going to make a change in the next release as we've had a few customers run into this issue recently, as we've developed a more efficient script which should hopefully help with this.

 

For now, if you can contact us via our support page on our web site (https://www.clickstudios.com.au/support.aspx) I can provide the SQL script to you now so you can run this manually in SQL Server Management Studio.

Regards

Click Studios

[support]

Hello Everyone.

As mentioned, we are making changes in the next build for this, and we've been doing some testing on performance here.
 

With this new script for mass deletion, we've been able to delete a parent folder which has 500 nested Folders, 2500 Password Lists and 12500 password records, in just under 3 minutes.
 

These times will obviously vary depending on the age of these records, and volume of related records in various tables, but at least this is an indication of performance.

Regards

Click Studios