> On Oct 21, 2014, at 10:32 PM, James Norman <[email protected]> wrote: > > I'm experiencing slow updates with large databases at 30-70K documents. It > takes over 50 seconds to delete 200 documents on a database with 50K > documents.
I don't normally weigh in on Android issues because I work on iOS, but this sounds suspiciously like iOS issue #487 <https://github.com/couchbase/couchbase-lite-ios/issues/487> (fixed for 1.0.3) which is a problem with the SQLite schema and could thus affect Android as well; I see Traun's cloned it to the java-core issue tracker as #297 <https://github.com/couchbase/couchbase-lite-java-core/issues/297> (still open.) The trigger for this issue is having SQLite 3.8 or higher. (It has a new query planner, which interacts badly with a poorly-designed index that's been in CBL for a long time, resulting in a super-inefficient index scan during document insertion.) That's why we didn't notice it until recently — the only Apple OS that has SQLite 3.8 yet is Mac OS X 10.10 (Yosemite). I don't know an easy way to tell what version of SQLite is present on an Android device. Maybe it's in the OS release notes somewhere; otherwise you'd have to make a call to the SQLite C API. (What OS version does your device have?) —Jens -- You received this message because you are subscribed to the Google Groups "Couchbase Mobile" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/mobile-couchbase/002D0E54-497E-45AF-99B0-4C3CEE747798%40couchbase.com. For more options, visit https://groups.google.com/d/optout.
