in reply to Re: Storable - File empties itself?
in thread Storable - File empties itself?
I'll keep you updated if we could make sure it's the "store" from different processes
I very rarely gamble, but I'll bet that this is your problem.
My experience of writing inter-process communication software with shared storage using Storable says that you are having collisions that result in broken writes.
You need to provide adequate exclusive locking mechanisms, which isn't easy.
You're running a CRM. That, by default means you may have multiple entries at once, all the time. You're likely only going to grow, so patching this with locks is not sustainable nor is it scalable.
Rewrite all of it to use a proper database. Doing anything else is a temporary band-aid and will only cost your company money for nothing.
Having a (potentially growing) multi-user input all using the same single output file is like pouring an ever increasing amount of liquid into a funnel and expecting the funnel to allow the increasing amount of liquid to flow through. It won't, no matter what you do.
Even if you successfully manage to set up a proper locking mechanism (trust me, this is hard), there's always the single-file contention. You will forever have problems no matter what.
To further, Storable is a proprietary format. Don't use it for the type of storage you're using it for. Serialize your data in a standard format.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^3: Storable - File empties itself?
by stevieb (Canon) on Apr 18, 2023 at 09:12 UTC | |
Re^3: Storable - File empties itself?
by Anonymous Monk on Apr 18, 2023 at 10:05 UTC | |
by stevieb (Canon) on Apr 18, 2023 at 10:20 UTC |