iPad: Poor performance in updating document


#1

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.


#2

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.