v7.1.0 was released on TBD for in-house customers.
Configure Snapshot Isolation for SQL Server Databases
If you are using SQL Server as your external database, you must configure Snapshot Isolation to minimize deadlocks only for your frevvo database schema. This is recommended when you are setting up SQL Server for the first time or you are upfrading
Although MySQL and Oracle databases are set up to do this by default, SQL Server is not.
It is recommended that SQL Server customers should at the minimum:
- Turn on the READ COMMITTED SNAPSHOT setting in the database to ensure that reads don’t block writes.
This can be done:
Using DDL ( data Definition Language) - Run the commands listed below
ALTER DATABASE <your frevvo database schema> - replace <your frevvo database schema> with the name of your frevvo database schema then execute the statement below:SET READ_COMMITTED_SNAPSHOT ON
- Using SQL Server Management Studio:
- Turn on the “Is Read Committed Snapshot On” Option under database properties
New Submissions View
The New Submissions View provides the ability to search submissions by fields in your form/flow, metadata fields or logical expressions that you create. The UI makes it very easy to specify search criteria. The Legacy Submissions view is also available in this release but...
You do not have to restart the Insight server every time you restart
This is the SQL Server article on minimizing deadlocks. It is recommended that SQL Server users should at the minimum:
Turn on the READ COMMITTED SNAPSHOT setting in the database to ensure that reads don’t block writes.
This can be done using DDL:
ALTER DATABASE MyDatabase
SET READ_COMMITTED_SNAPSHOT ON
Or it can be done via the SQL Server Management Studio (“Is Read Committed Snapshot On” Option under database properties)