react-native-sqlite-storage icon indicating copy to clipboard operation
react-native-sqlite-storage copied to clipboard

sqlBatch - make starting a transaction optional

Open allie-wake-up opened this issue 5 years ago • 1 comments

I've found that using sqlBatch can cause large performance improvements for me, but sometimes I want to do more than 1 batch in a single transaction. I added an optional parameter so that the default behavior doesn't change and this is backwards compatible.

allie-wake-up avatar May 11 '20 20:05 allie-wake-up

@TheKiteEatingTree Hi. I'm sorry, but how can I use a sqlBatch with this plugin? I need to perform some large operations (with about 200k lines), and using a default INSERT within a transacion is very slow and even causing crashes. I did't find any way to execute it as batches. Can I use your approach? Can you share an example? Thanks!

EduFrazao avatar Aug 13 '21 22:08 EduFrazao