Please post a brief sample demonstrating the issue and someone will have a look. It is virtually impossible without even knowing what plugin you are using .... Gut reaction is the android code is doing something wrong, but it's hard to know with a concrete example.
My team is hiring! @purplecabbage risingj.com On Tue, Jul 21, 2015 at 8:12 AM, Rob Sherman < rob.sher...@medicaltracking.com> wrote: > 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 > >