Cyrus database and file usage data
thomas.jarosch at intra2net.com
Thu Jun 9 16:40:05 EDT 2016
Am 08.06.2016 um 08:22 schrieb Bron Gondwana via Cyrus-devel:
> *THE PLAN[tm]***
> For JMAP support, I'm going to discard the existing conversations DB and
> create a sqlite database per user which contains everything of value.
one thing to watch out for with sqlite:
It doesn't scale easily with multiple processes accessing the same DB.
The write-lock timeout is short by default and a "modifying"
query might error out.
If this per-user DB will be used by multiple processes
(think multiple JMAP connection in parallel from a web frontend)
+ LMTP delivery at the same time, this might occur sooner or later.
I've learned about this issue the hard way with a central sqlite DB
for ActiveSync device management on our horde installation.
More information about the Cyrus-devel