greenDAO 40 seconds to insert 600 records

Question

I've chosen greenDAO because it's site states that it's one of the fastest ORM systems for android. To my dissapointment it takes it like 40 seconds to insert 600 records on Samsung i9001. I'm not sure if I'm doing anything wrong.

Could you suggest anything to lessen the amount of time it takes to perform those operations ?

generator code:

private static void addNewsArticle(Schema schema) {
    Entity article = schema.addEntity("NewsArticle");
    article.addIdProperty().autoincrement();
    article.addStringProperty("title").notNull();
    article.addStringProperty("body").notNull();
    article.addStringProperty("shortDescription").notNull();
    article.addStringProperty("thumb");
    article.addDateProperty("date").notNull();
}

insertions

Date now = Calendar.getInstance().getTime();
for (int i = 0; i < 600; i++) {
    NewsArticle testArticle = new NewsArticle();
    testArticle.setTitle("title-text" + i);
    testArticle.setBody("body-text" + i);
    testArticle.setShortDescription("short-text" + i);
    testArticle.setDate(now);
    newsArticleDao.insert(testArticle);
}

score 42 · Accepted Answer · edited May 14 '14 at 06:39

42

As I suspected things weren't executed within a single sql statement. In order to achieve it just use insertInTx on a DAO object.

Here's the above code with slight changes that make it run in like half a second

NewsArticle[] newsArticles = new NewsArticle[600];
NewsArticle testArticle;
    for (int i = 0; i < 600; i++) {
         testArticle = new NewsArticle();
         testArticle.setTitle("title-text" + i);
         testArticle.setBody("body-text" + i);
         testArticle.setShortDescription("short-text" + i);
         testArticle.setDate(now);
         newsArticles[i] = testArticle;
    }
newsArticleDao.insertInTx(newsArticles);

edited May 14 '14 at 06:39

thepoosh

12,497
15
73
132

answered Oct 07 '12 at 14:08

midnight

3,420
3
36
58

4

you saved my ass in 3 years before. – Youtoo Aug 18 '15 at 03:14
I prove the load of my database (from 01:30 min to ~1s). Thanks very much!. – VIX Jul 12 '17 at 16:56

score 9 · Answer 2 · answered Nov 07 '12 at 09:53

you can also create a new Runnable that does all the inserts runs within the DaoSession.runInTx function

daoSession.runInTx(new Runnable {
    public void run(){
        Date now = Calendar.getInstance().getTime();
        for (int i = 0; i < 600; i++) {
             NewsArticle testArticle = new NewsArticle();
                     testArticle.setTitle("title-text" + i);
                     testArticle.setBody("body-text" + i);
                     tesArticle.setShortDescription("short-text" + i);
                     testArticle.setDate(now);
                     newsArticleDao.insert(testArticle);
        }
   }
});

score 1 · Answer 3 · answered Apr 06 '13 at 08:50

1

An excellent article on speeding up SQLITE insert operations for Android is given here. Tryout this I could optimize the sync modules speed dramatically from 1.2 hours to 14 mins in syncing 39MB DB.

http://tech.vg.no/2011/04/04/speeding-up-sqlite-insert-operations/

Let me know in case if you need code spinnets.

answered Apr 06 '13 at 08:50

user1935071

31
2

That is an excellent article, but greenDAO already has optimizations in place for using transactions. User midnight's answer is the best one. – Austin B May 07 '13 at 02:56

score 0 · Answer 4 · answered Mar 28 '15 at 12:11

I tried below mentioned and got the best performance

        DevOpenHelper helper = new DaoMaster.DevOpenHelper(this, "db-name",
                null);
        SQLiteDatabase dbGreen= helper.getWritableDatabase();

        dbGreen.beginTransaction();

        //Perform your insertion here
        dbGreen.setTransactionSuccessful();
        dbGreen.endTransaction();

greenDAO 40 seconds to insert 600 records

4 Answers4

Linked