2020.2

To cure this issue, it is recommended that you periodically run manual maintenance on the
backend database.
If using MySQL, the following script should be run in a query window:
set @a=null,@c=null,@b=concat("show tables where",ifnull(concat("
`Tables_in_",database(),"` like '",@c,"' and"),'')," (@a:=concat_ws
(',',@a,`Tables_in_",database(),"`))");
Prepare `bd` from @b;
EXECUTE `bd`;
DEALLOCATE PREPARE `bd`;
set @a:=concat('optimize table ',@a);
PREPARE `sql` FROM @a;
EXECUTE `sql`;
DEALLOCATE PREPARE `sql`;
set @a=null,@b=null,@c=null;
If using Microsoft SQL Server run the following command in a query window:
sp_updatestats
Windows 10 Search service impacting Connect
The Windows 10 Search service runs as a background task, indexing files and folders. It has
been noted that this background task is sometimes preventing files being added to the Connect
temporary files folder when large amounts of files are being output and copied.
If this is an issue for you, we suggest disabling Search Indexing on the
C:\Users\<username>\Connect folder.
This issue will be fixed in a later release.
Page 94