You are viewing limited content. For full access, please sign in.

Question

Question

Performance Issues with Large Volume of Holds in Laserfiche

asked on August 22

Hi all,

We’ve been experiencing performance issues related to document holds in Laserfiche. Specifically, the system is crashing when processing holds, and I've been tasked with applying holds to a document set that now exceeds 500,000 items.

Has anyone else worked with a hold volume of this size? If so, did you encounter issues such as increased memory or CPU usage, or significant delays—such as documents taking up to 3 minutes to open?

I’d appreciate hearing about your experiences or any recommendations you may have for managing holds at this scale.

1 0

Replies

replied on August 28

If you're using Laserfiche Server 11, please make sure that you have the latest update applied. See https://support.laserfiche.com/kb/1014568/list-of-changes-for-laserfiche-server-11-update-3

  • Resolved an issue that could lead to excessive memory usage and degraded performance when working with records under hold. (575351, 574338, 559334, 573964)
2 0
replied on August 28

Having large holds or many holds shouldn't cause a performance problem by itself. Each entry under hold is represented by a simple relation row in a database table, so even a million entries in a hold is not very much data. But it is possible that your system was at its limit just before this. You'll want to take a look at the SQL Server first, and make sure that has the resources it needs.

It's also possible that something else changed around the same time, and the holds turn out to be a red herring. Especially since you mention that opening a document is slow. When you open a document, I don't think it fetches the hold list unless the user explicitly chooses to do that. Until then, it just checks if there is a single applicable hold, which should be fast. Is there a performance problem interacting with a document that is not a part of any hold?

When you say that it's "crashing when processing holds", can you clarify what action you are taking in the application, and what you see when it doesn't work? If there is an error shown to the user, often there is additional information in the event logs on the servers.

You are not allowed to follow up in this post.

Sign in to reply to this post.