Slow search for a folder

asked on February 13, 2014

Hello,

I am experiencing a very, very slow search in my repository. What I am trying to find is any folder with a certain field value (the field is named record ID). I am running a "Field" and "Document/Folder name" search. Here is the search syntax I'm using: {[]:[Record ID]="4233"} & {LF:Name="*", Type="F"}

Every other search is super fast, no issues. Using the search syntax above it took 32 seconds to find 1 entry. Taking off the "document/folder name" and leaving on the "field" search it took just 2 seconds to find 414 entries.

Several workflows and an integration between my CRM software and Laserfiche use this search to find the correct folder to file documents in. At certain times, we may have 200-300 documents that the system is trying to file using that slow search.

Is there any way to speed up this search at all? I'm assuming the wild card in the folder name is the slow part of the search?

Some technical info just in case it's helpful:

- We're on version 9.1.0.409

- We're running SQL express version 2008 R2

- Our repository has 283,433 entries total

- Anything else that would be helpful to know?

Thanks in advance for any suggestions!

0 0

SELECTED ANSWER

replied on February 13, 2014

The issue here is the "*". It builds a temporary table with all folders, then it matches all of those folders to record 4233. If you system is designed for ease of use and thus uses folders extensively (as you should) this particular search is fairly slow.

One thing I would consider is to build your root folders with an extra field called "Root Folder", and place a Y in that field. That way you could build a search that looked for all records with a 4233 and a y in the root folder field.

3 0

View 1 previous reply

replied on February 13, 2014

No problem! This one was perplexing to me in the past until I learned exactly how searches work. Any search you do with a & in the middle builds both sides of the search and then compares the two. So you have to make sure both of them are as narrow as can be to get fast results.

0 0

replied on February 13, 2014

I was told that 9.1.1 would be able to handle "*" searches better - does anyone know if this is still the case?

0 0

replied on February 19, 2014

This issue still exists with 9.1.1

http://answers.laserfiche.com/questions/50935/Laserfiche-91-and-911-problemsbugs-Please-help

0 0

Question

Question

Answer

Replies

Sign in to reply to this post.