为什么使用SQLite事务插入数据速度这么慢
QTime *timer = new QTime;
timer->start();
QSqlQuery insertQuery;
QString query;
QVariantList one, two, three, four, five, six, seven, eight;
db.transaction(); //开始一个事务
insertQuery.prepare("insert into CheckRecord values(?,?,?,?,?,?,?,?)");
for (int i = 0; i < YValues.size(); i++)
{
for (int j = 0; j < YValues[i].size(); j++)
{
one << UUid::getUUid();
two << QString::number(j + 1);
three << TrackID;
four << checkTime[i];
five << stepList[i] * dx;
six << 0;
seven << YValues[i][j];
eight << DefectPercent[i][j];
}
}
insertQuery.addBindValue(one);
insertQuery.addBindValue(two);
insertQuery.addBindValue(three);
insertQuery.addBindValue(four);
insertQuery.addBindValue(five);
insertQuery.addBindValue(six);
insertQuery.addBindValue(seven);
insertQuery.addBindValue(eight);
insertQuery.execBatch();
db.commit(); //提交
qDebug() << timer->elapsed();
这样基本是插入100条数据就需要1秒,为什么我看别人的使用SQLite事务插入数据很快,而我的与别人相比就慢了不少,或者我要如何优化这个