react-native-sqlite-storage
react-native-sqlite-storage copied to clipboard
andpor
App crashing on big transaction
Hi. I'm trying run a transaction, that will insert many rows (in this specific case, ~270k rows, on a table with two colmns (numeric, and text with max of 64 charts).
After few seconds after dispatch all querys using tx.executeSQL, the app freezes at physical devices and emulator, and I got many GC Logs until a out of memory crash:
08-14 13:01:10.832 17435 17457 I com.vitruvio: Alloc concurrent copying GC freed 299(22KB) AllocSpace objects, 0(0B) LOS objects, 0% free, 191MB/192MB, paused 34us total 944.451ms
08-14 13:01:10.832 17435 17435 I com.vitruvio: WaitForGcToComplete blocked Alloc on HeapTrim for 1.673s
08-14 13:01:10.832 17435 17435 I com.vitruvio: Starting a blocking GC Alloc
08-14 13:01:10.832 17435 17435 D AndroidRuntime: Shutting down VM
08-14 13:01:10.833 17435 17449 I com.vitruvio: WaitForGcToComplete blocked Background on HeapTrim for 9.508s
08-14 13:01:10.833 17435 17848 I com.vitruvio: WaitForGcToComplete blocked Alloc on HeapTrim for 10.171s
08-14 13:01:10.834 17435 17848 I com.vitruvio: Starting a blocking GC Alloc
08-14 13:01:10.834 17435 17491 I com.vitruvio: Waiting for a blocking GC Alloc
08-14 13:01:10.834 17435 17513 I com.vitruvio: Waiting for a blocking GC Alloc
08-14 13:01:10.834 17435 17451 I com.vitruvio: Waiting for a blocking GC Alloc
08-14 13:01:10.834 17435 17841 I com.vitruvio: Waiting for a blocking GC Alloc
08-14 13:01:10.835 17435 17467 I com.vitruvio: Waiting for a blocking GC Alloc
08-14 13:01:10.835 17435 17496 I com.vitruvio: Waiting for a blocking GC Alloc
08-14 13:00:58.566 846 846 F libc : crash_dump helper failed to exec
08-14 13:01:10.854 17435 17435 E AndroidRuntime: FATAL EXCEPTION: main
08-14 13:01:10.854 17435 17435 E AndroidRuntime: Process: com.vitruvio, PID: 17435
08-14 13:01:10.854 17435 17435 E AndroidRuntime: java.lang.OutOfMemoryError: OutOfMemoryError thrown while trying to throw an exception; no stack trace available
If I split this job in many transactions (tested transactions of 50k statements), I can complete the work, but without transactional security. Using db.sqlBatch I have the same behavior.
I'm moving from cordova, to react native, and today I have the same workload on Cordova with SQLite, using cordova-sqlite-storage and I can run this big transactions without problems.
In fact, with my cordova application, I run this transaction in about 10 seconds. Spliting in several transactions here, to be able to manage the dataset without crash the application, I was able to run the same job in 70 seconds.
There is any way to improve performance? I'm doing something wrong?
