SUPPORT / SAMPLES & SAS NOTES
Problem Note 34800: Performance decreases as the FSK_ALERT table increases in size when closing alerts.
 |  |  |  |  |
Performance progressively degenerates when closing alerts in SAS® Money Laundering Detection as the volume of alerts, both active and closed, grows within the FSK_ALERT table.
This is due to use of the SCL method _findRow, which does not use the index for FSK_ALERT. To resolve this performance issue, the _findRow method is replaced with a DATA step and MODIFY command which will use the index for FSK_ALERT.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Money Laundering Detection | Microsoft® Windows® for x64 | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Advanced Server | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows NT Workstation | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Windows Vista | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||