Hello,
We are using iPad 2017 model, Below is a sample document information which has an array of 2300 items - we update maximum of 20 items and it takes 20+ seconds.
document size: 600kb
lines: 27000
total characters:614386
we are using javascript core to update the lite db. Can you please suggest what else can be done to get the update quickly.
The best advice is to not use huge documents like this! Parsing or generating that much JSON is expensive. If you break this up into multiple small documents, then modifying a few of those only requires working with a small amount of JSON. (Plus, using huge documents defeats the purpose of having a database.)
As a rule of thumb, documents should probably be under 16KB IMHO.