Question

Does Laserfiche Have the Option to Load the Repository Database into Memory?

Laserfiche Administration

Updated June 7, 2018

asked on June 7, 2018

We have a client that has a VM configuration that has a lot of RAM and were wondering if Laserfiche has an option to tell it to load the repository database into memory? I mentioned that I believe SQL had an option to do that, but they have had bad experiences with using the SQL configuration.

1 0

Answer

SELECTED ANSWER

replied on June 7, 2018

There is no flag or command that tells SQL Server to load a database into memory, though if you allow SQL Server access to enough RAM it won't need to evict data that has been brought into memory. That's the idea behind this approach: https://stackoverflow.com/a/23816371/

0 0

Replies

replied on June 7, 2018 • Show version history

I'm not sure I understand. The entire point of having a database server is so that data is written to and kept on disk (which is persistent) and doesn't have to be stored in memory (which is not persistent, i.e. you lose it during reboots etc.).

There are in-memory data stores that also provide persistence (such as Redis) but they tend to be designed for rather specialized functions.

SQL Server already has caching mechanisms to keep regularly accessed data in memory so that it is quicker to access. I'm sure LF Server, Forms and WF also do their own caching. But I've never heard of an application loading its entire database into memory or anything of the sort.

0 0

replied on June 7, 2018

Ege, I'm not sure I completely understand their wanting to do it, but I told them I would ask.

1 0

replied on June 7, 2018

I would guess that they were referring to memory-optimized tables? Laserfiche's architecture does not make it suitable for that.

0 0

You are not allowed to follow up in this post.

Question

Question

Does Laserfiche Have the Option to Load the Repository Database into Memory?

Answer

Replies

Sign in to reply to this post.