?

?Android OS中的DatabaseUtils.InsertHelper类提供的方法能够提高对sqlite数据库的insert速度 。但是，有关其使用的文档说明或者例子很少。希望这篇文章能有助于帮你揭开其神秘的面纱。
????? 我们经常有在SqliteOpenHelper的onCreate方法里面批量进行insert操作的情况，所以这个例子参照这种情景【已有隐式事务】 (批量处理意味着包含了有事务处理，我们知道，使用事务对程序的performance有影响，下面会有介绍）

假设onCreate方法如下：

private class DatabaseHelper extends SQLiteOpenHelper {
    @Override
    public void onCreate(SQLiteDatabase db) {
        ContentValues values = new ContentValues();
        while (moreRowsToInsert) {
            // ... create the data for this row (not shown) ...
           // Add the data for each column
            values.put( "Greek" , greekData);
            values.put( "Ionic" , ionicData);
            // ...
            values.put( "Roman" , romanData);  
            // Insert the row into the database.
            db.insert( "columnTable" , null , values);
        }
    }
    //...
}

?
使用DatabaseUtils.InsertHelper,则代码如下：

import android.database.DatabaseUtils.InsertHelper;
//...
private class DatabaseHelper extends SQLiteOpenHelper {
    @Override
    public void onCreate(SQLiteDatabase db) {
        // Create a single InsertHelper to handle this set of insertions.
        InsertHelper ih = new InsertHelper(db, "columnTable");
        // Get the numeric indexes for each of the columns that we're updating
        final int greekColumn = ih.getColumnIndex("Greek");
        final int ionicColumn = ih.getColumnIndex("Ionic");
        //...
        final int romanColumn = ih.getColumnIndex("Roman");
        while (moreRowsToInsert) {
            // ... Create the data for this row (not shown) ...
            // Get the InsertHelper ready to insert a single row
            ih.prepareForInsert();
            // Add the data for each column
            ih.bind(greekColumn, greekData);
            ih.bind(ionicColumn, ionicData);
            //...
            ih.bind(romanColumn, romanData);
            // Insert the row into the database.
            ih.execute();
        }
    }
    //...
}

public void onCreate(SQLiteDatabase db) {
    //...
    try 
    {
        // *Temporarily* (have I emphasized that enough?) disable
        // thread locking in the database. Be sure to re-enable locking
        // within a finally block.
        db.setLockingEnabled(false );
        // ... load the database ...
    }
    finally 
    {
        db.setLockingEnabled(true );
    }