Transaction Search is running slowly on SQL Server 2016 compatibility level 130 or higher.

When running SQL Server 2016 compatibility level 130 or higher, users have noticed that running a "Transaction Search" takes around 20 seconds to find a single transaction when doing a search using the "Revenue ID" in the search form. 

Doing the same search using compatibility level 110 (SQL 2012 DB level) returns a result almost instantly. 
We’re currently evaluating this issue for a fix in a future release.

Environment

 Blackbaud CRM
 4.0
 4.0.180.1600

Was this article helpful?