Folder Browsing May Be Slow for Large Folders When Using Microsoft SQL Server 2000.

August 28, 2008 | KB: 1012042
Laserfiche Server - Team (MSDE) 8, Laserfiche Server - United (MS SQL) 8, Laserfiche 9

Summary

The Folder Browser may be slow when viewing large folders if you are using Microsoft SQL Server 2000.

Cause

Laserfiche relies on the ROW_NUMBER function in Microsoft SQL Server 2005 to decrease load times when browsing a large folder. However, the function is only available starting with Microsoft SQL Server 2005.

Workaround

Upgrade to Microsoft SQL Server 2005 or later. This issue also does not affect Oracle databases.