对比在android中批量插入数据的3中方式对比（各插入1W条数据所花费的时间）：

1、 一个一个插入

 publicstaticboolean insert(SQLiteOpenHelper openHelper,              RemoteAppInfo appInfo) {          if (null == appInfo) {              returntrue;          }          SQLiteDatabase db = null;          try {              db = openHelper.getWritableDatabase();              ContentValues values = appInfo.getContentValues();              return -1 != db.insert(RemoteDBHelper.TABLE_APP_REMOTE, null,                      values);          } catch (Exception e) {              e.printStackTrace();          } finally {              if (null != db) {                  db.close();              }          }          returnfalse;      }      for (RemoteAppInfo remoteAppInfo : list) {            RemoteDBUtil.insert(helper, remoteAppInfo);         }

耗时：106524ms,也就是106s

2、 开启事务批量插入，使用SqliteDateBase中的insert(String table, String nullColumnHack, ContentValues values)方法

publicstaticboolean insert(SQLiteOpenHelper openHelper,          List<RemoteAppInfo> list) {      boolean result = true;      if (null == list || list.size() <= 0) {          returntrue;      }      SQLiteDatabase db = null;      try {          db = openHelper.getWritableDatabase();          db.beginTransaction();          for (RemoteAppInfo remoteAppInfo : list) {              ContentValues values = remoteAppInfo.getContentValues();              if (db.insert(RemoteDBHelper.TABLE_APP_REMOTE, null, values) < 0) {                  result = false;                  break;              }          }          if (result) {              db.setTransactionSuccessful();          }      } catch (Exception e) {          e.printStackTrace();          returnfalse;      } finally {          try {              if (null != db) {                  db.endTransaction();                  db.close();              }          } catch (Exception e) {              e.printStackTrace();          }      }      returntrue;  }

耗时：2968ms

3、 开启事务批量插入，使用SQLiteStatement

  publicstaticboolean insertBySql(SQLiteOpenHelper openHelper,              List<RemoteAppInfo> list) {          if (null == openHelper || null == list || list.size() <= 0) {              returnfalse;         }          SQLiteDatabase db = null;         try {              db = openHelper.getWritableDatabase();             String sql = "insert into " + RemoteDBHelper.TABLE_APP_REMOTE + "("                      + RemoteDBHelper.COL_PKG_NAME + ","// 包名                      + RemoteDBHelper.COL_USER_ACCOUNT + ","// 账号                      + RemoteDBHelper.COL_APP_SOURCE + ","// 来源                      + RemoteDBHelper.COL_SOURCE_UNIQUE + ","// PC mac 地址                      + RemoteDBHelper.COL_MOBILE_UNIQUE + ","// 手机唯一标识                      + RemoteDBHelper.COL_IMEI + ","// 手机IMEI                      + RemoteDBHelper.COL_INSTALL_STATUS + ","// 安装状态                      + RemoteDBHelper.COL_TRANSFER_RESULT + ","// 传输状态                      + RemoteDBHelper.COL_REMOTE_RECORD_ID // 唯一标识                      + ") " + "values(?,?,?,?,?,?,?,?,?)";             SQLiteStatement stat = db.compileStatement(sql);             db.beginTransaction();             for (RemoteAppInfo remoteAppInfo : list) {                  stat.bindString(1, remoteAppInfo.getPkgName());                 stat.bindString(2, remoteAppInfo.getAccount());                 stat.bindLong(3, remoteAppInfo.getFrom());                 stat.bindString(4, remoteAppInfo.getFromDeviceMd5());                 stat.bindString(5, remoteAppInfo.getMoblieMd5());                 stat.bindString(6, remoteAppInfo.getImei());                 stat.bindLong(7, remoteAppInfo.getInstallStatus());                 stat.bindLong(8, remoteAppInfo.getTransferResult());                 stat.bindString(9, remoteAppInfo.getRecordId());                 long result = stat.executeInsert();                 if (result < 0) {                      returnfalse;                 }              }              db.setTransactionSuccessful();         } catch (Exception e) {              e.printStackTrace();             returnfalse;        } finally {              try {                  if (null != db) {                      db.endTransaction();                     db.close();                 }              } catch (Exception e) {                  e.printStackTrace();             }          }          returntrue;     }

耗时：1365ms

更多相关文章

  1. android 使用SQLiteOpenHelper类批量执行sql问题
  2. Android(安卓)耳机插入过程分析
  3. Android批量插入数据
  4. Android(安卓)PrecomputedTextCompat
  5. android p 充拔电提示音
  6. Android(安卓)LayoutInflater inflate方法效率
  7. Android(安卓)数据库批量查询数据的操作
  8. Android(安卓)高性能编码一：多线程并发或分布式提高TPS
  9. 批量反编译Android(安卓)XML文件Python脚本

随机推荐

  1. Android游戏引擎《Rokon》学习笔记六：一个
  2. Android(安卓)网络框架初探
  3. Android(安卓)OpenGLES绘制yuv420纹理
  4. Android(安卓)HandlerThread源码解析
  5. android proguard混淆apk问题
  6. The import org.cocos2dx.lib cannot be
  7. PianoView-添加一行代码使用[最美应用]的
  8. 实战Linux Bluetooth编程（三） HCI层编程
  9. Android(安卓)调节屏幕亮度问题
  10. Android传感器各种解释