Slow Filr performance with MS SQL 2016 and 2017

  • 7024927
  • 16-Nov-2020
  • 18-Nov-2020

Environment

Micro Focus Filr 4.x
Microsoft SQL Server version 2016
Microsoft SQL Server version 2017

Situation

Filr performance, such as browsing files, logging in, loading files, etc is very slow when the database server is Microsoft SQL Server versions 2016 or 2017

Resolution

Refer to the Microsoft SQL Server documentation to enable LEGACY_CARDINALITY_ESTIMATION.