bug: native is almost 10x slower than web when selecting 15mb data

[mustafa0x]

I have a database containing ~15mb of data. On the same device, native is almost 10x slower than web. See the following image (native is first). iOS is faster than android, but still far slower. I think the problem is lots of serialization.

• Plugin version: 6.0.2
• Platform(s): native

[chris-si]

I am also experiencing performance issues on iOS where simple queries on a pretty small database sometimes take multiple seconds to complete.
Unfortunately I wasn't able to pinpoint the exact point in time when this behavior started (e.g. after an update of the library or so) since it only came to my attention quite recently.

[abdulraheemawan]

Is there any update on this?
Here is results that i get for ~48000 inserts using executeSet(). It takes around 135042.40893554688 ms which is an absurd amount of time for a sqlite db. My findings also indicate that it is caused by improper use of memory and serialization.

[robingenz]

@abdulraheemawan No updates so far. Feel free to submit a PR.