Performance issues

[jshearer]

I'm using this library in conjunction with pouchdb-adapter-react-native-sqlite ultimately to act as a performant backend for RxDB: our use case is supporting potentially offline devices.

I'm encountering a whole bunch of strange performance issues when running on Android specifically -- things seem to be very snappy on iOS.

I managed to get the Android profiler working, and came up with some results that I'm not sure how to interpret. It certainly looks like there are quite a few SQLite threads that are active during times that I'm doing database activity, and when I go look at their behaviour, I see things like String.charAt and looking items up from a hashmap as the source of a lot of the time spent. I'll attach some screenshots from the profiler, but if anyone has experienced this and has any ideas I'd love to hear them. Note that these performance issues do not seem to show up on iOS at all, everything is very snappy.