search

storesafe / cordova-sqlcipher-adapter

A Cordova/PhoneGap plugin to create and access encrypted databases on Android, iOS, and Windows with API similar to HTML5/Web SQL API
Other
89 stars 55 forks source link

Very slow on Android 7, 8 but working fine on Android 9 and 10 #89

Closed azn1viet closed 5 years ago

azn1viet commented 5 years ago

I got the same app which is testing against Android 7,8,9,10. I got insert like 4000 batch records each time. While Android 9,10 is running fine each batch took about 10 seconds; Android 7 took 30 seconds and Android 8 took 2-3 mins.

The older version 0.1.9 was inserting exact the same mount of time Android 9, 10 currently do for Android 7, 8. But Google has rejected older Cordova compilation for Cordova Android 6.4.0 and below. We must upgrade to Cordova Android 8. Eventually, I can't use 0.1.9 nor 0.2.1 to run the app due to incompatibility.

Not sure if those info confused you, but the latest 4.1.0 (or you said 4.2.0, but the version is still 4.1.0) is very slow on Android 7, 8 from 10 seconds to 3 mins for 4k records.

Could any one share experience if it's degraded performance on Android 7, 8?

azn1viet commented 5 years ago

Not sure what the issue was but I reverted the plugin to version 0.2.1 and it's working well on all Android versions.