Hello Cordova Dev's. My company develops a mobile inventory/ERP client/scheduling/Logistics App for the medical industry. We support iOS and Android (and possibly Windows Tablets soon) We are seeing (as are many others) extreme differences in SQLite data load times between iOS and Android. We have applied every optimization and tried nearly anything and everything on Stack overflow.
A data load (lets call it an initial data load) for a large client with a lot of data takes 1h 57s 342ms on Android -the same code and same plug-in on iOS takes less than 0h 6m 112ms to do the same work. This is a radical difference, to be sure. I understand the plug-in developer is likely a better contact on this, however; 1. In the enterprise market, which is growing fast, local DB can be considered a core competancy. 2. After applying every possible technique, including not transaction wrapping each insert-the gains are marginal. 3. This seems to indicate a platform difference better addressed centrally We are "getting creative" in that we are trying locking preferences and even waiting to apply triggers until after init data load -this is in development for POC and dev testing now but I haven't had result reports to review yet, so I can't detail the effectiveness, yet. Any help/direction and/or action is sincerely appreciated-and by no means expected, I am guessing you are at least aware there is difference. Hopefully my voice added to other might spur an organization wide discussion that leads to equality of SQLite performance across platforms as the very nature of Cordova and the HTML5/JavaScript components manage to do achieve parity. Sincerely, Rob Sherman, Mobile Architect, MTS
