我可以改进这段代码以更快地读取和写入数据吗

Question

我有一些我一直在玩的示例代码。基本上我只是从 csv 文件读取并写入表中。是否可以改进以下内容，使其速度更快，看起来很慢

public void impcusdata() throws SQLException, IOException {
    try {

        String UnitID = getUnitID();
        FileReader fr = new FileReader("/mnt/sdcard/CRM.CSV");

        // Put the file into the buffer
        BufferedReader in = new BufferedReader(fr);
        db.execSQL("DELETE FROM " + CUSTOMER_TABLE);
        // Create a new string to hold the data
        String data = "";

        // Create the strings executing SQL commands for the data to be
        // inserted
        String InsertCustString = "INSERT INTO " + CUSTOMER_TABLE
                + " VALUES(";
        String InsertEndString = ");";

        // If there is any data in the .CSV file then read it.
        while ((data = in.readLine()) != null) {
            // String the results to the SQL database
            db.execSQL(InsertCustString + data + InsertEndString);
        }
    } catch (SQLiteException ex) {
        String Shaw = ex.getMessage();

    }
    // log entry to the LogCat file
    Log.v(TAG, "Customer Table has been updated");
}

Answer 1

是的，使用 SqliteDatabase.beginTransaction() 与 setTransactionSuccessful() 和 endTransaction() 您可以组合多个查询。