Notes on Android SQLite bulk insert

There's no real bulk insert in SQLite I'm aware of to date. I've tried various ways to insert data fast into Android's SQLite DB, and here are my notes:
1. Use transactions. (e.g. db.beginTransaction, etc..).
2. Use compiled statement: db.compileStatement(insertStatementString), it's much faster than db.insert().

So, in short:

db.beginTransaction();
try {
    string sql = "insert into products (id) values (?)";
    SQLiteStatement insert = db.compileStatement(sql);

    for (.....) {
        insert.bindLong(1, 12345);
        insert.executeInsert();
    }
    db.setTransactionSuccessful();
} finally {
    db.endTransaction();
}