Performing a Search On All Fields May Be Significantly Slower Than Performing A Search On One Field.

July 21, 2008 | KB: 1012018

https://support.laserfiche.com/kb/1012018/performing-a-search-on-all-fields-may-be-significantly-slower-than-performing-a-search-on-one-field-

Laserfiche Server - Team (MSDE) 8, Laserfiche Server - United (MS SQL) 8

Search performance may be significantly slower when performing a search across all fields compared to performing a search on one specific field when using Microsoft SQL Server.

This issue is resolved in new repositories created with Laserfiche Server 8.0.1 when using Microsoft SQL Server 2005 or later. Laserfiche 8.0.1 creates an index on the str_val column in the propval table.

Laserfiche 8.0.1 does not create this index on express editions of Microsoft SQL Server 2005 as the index can significantly increase the size of your SQL database. In addition, Laserfiche 8.0.1 will not automatically create this index on existing SQL Server 2005 databases if you are upgrading from Laserfiche 8.0.0. Please see the following workaround if you wish to manually create the index on your database.

Run the following SQL command on your Microsoft SQL Server 2005 database:

create index propval_str_val_ix on propval (prop_id, tocid) include (str_val)