StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to insert bulk data in android sqlite database using ormlite efficiently
text
Body
copied!<p>I'm trying to insert 100000 records in android sqlite database at a time. I'm using following two different methods. </p> <pre><code> private void bulkInsertDataBySavePoint(final List<User> users) { log.debug("bulkInsertDataBySavePoint()"); DatabaseConnection conn = null; Savepoint savepoint = null; try { conn = userDao.startThreadConnection(); savepoint = conn.setSavePoint("bulk_insert"); for (User user : users) { userDao.create(user); } } catch (SQLException e) { log.error("Something went wrong in bulk Insert", e); } finally { if (conn != null) { try { conn.commit(savepoint); userDao.endThreadConnection(conn); } catch (SQLException e) { log.error("Something went wrong in bulk Insert", e); } } } } </code></pre> <p>And </p> <pre><code> private void bulkInsertDataByCallBatchTasks(final List<User> users) { log.debug("bulkInsertDataByCallBatchTasks()"); try { userDao.callBatchTasks(new Callable<Void>() { @Override public Void call() throws Exception { for (User user : users) { userDao.create(user); } return null; } }); } catch (Exception e) { e.printStackTrace(); } } </code></pre> <p>Both methods work fine. On average they take 140 seconds and take 60-65% CPU which is not ok, I think. </p> <p>The idea is, I have to consume an api which will provide json data. I have to parse that json data and then insert into sqlite database for offline usage. </p> <p>I'm looking for an efficient way to solve this issue. </p> <p>Any thought?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload