> Is this about multiple processes using the same database
For me, yes. I experience a pretty large performance hit on shared vs direct mode. That being said, shared mode does seem to work with multiple processes; However, all processes must be on the same machine, as he uses a mutex around critical code. Or at least, he did last time I looked at the codebase.
If your DB is on a network location and the processes are on different machines, bad things will happen.
My experience is that LiteDB in direct mode is faster than SQLite, but in shared mode is slower.
For me, yes. I experience a pretty large performance hit on shared vs direct mode. That being said, shared mode does seem to work with multiple processes; However, all processes must be on the same machine, as he uses a mutex around critical code. Or at least, he did last time I looked at the codebase.
If your DB is on a network location and the processes are on different machines, bad things will happen.
My experience is that LiteDB in direct mode is faster than SQLite, but in shared mode is slower.