News for hackers. Stuff that matters.
Re:One month with React Native by thedjinn on Tuesday May 16, 2017 @10:05AM (#14349642)
We are using SQLite. The performance bottleneck is not the database itself but conversion between the Java and JavaScript environments.
Re:One month with React Native by woah on Tuesday May 16, 2017 @12:01PM (#14350613)
Obviously almost every react native app out there is accessing a SQL db over the network, and they work fine. Are you seriously saying that it's slower to get data over the react native bridge than over the internet?
Re:One month with React Native by thedjinn on Tuesday May 16, 2017 @12:15PM (#14350758)
No, such a claim would be complete nonsense.

We are using a local database as a mirror for offline use, which is a key requirement. Profiling (a forgotten art nowadays) shows that most time spent during queries is in this bridge and not in the actual queries.

Re:One month with React Native by htormey on Tuesday May 16, 2017 @03:44PM (#14352643)
I know realm has a React Native library which I imagine you could use to access the db directly. Can you do something like that with SQLite? I.e access it without going through java/the bridge?
Re:One month with React Native by contingencies on Tuesday May 16, 2017 @10:50AM (#14350010)
What was the size of the result set?

Have you tried appending '... LIMIT <count> [OFFSET <skip>]' to constrain the per-query result set to a reasonable size?