2020.2

Table Of Contents

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 MySQL, the following script should be run 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.

Job Creation Presets: External Sorting change introduced in

2018.2

Versions prior to 2018.2 did not correctly save the line end characters for external sort

configurations in Job Creation Presets, which meant the job could not be externally sorted. This

issue has been fixed in version 2018.2. However, Job Creation Presets created with an earlier

version may still have the wrong line end character for external sorting. To fix this, open the Job

Creation Preset in the new version, reset the line end setting in the sorting options and then

save the preset.

Page 116