|
本帖最后由 baoniu 于 2013-9-23 00:14 编辑
09年的机器,4G内存,AMD5200
插入数据库用了2797毫秒- QSqlDatabase db=QSqlDatabase::addDatabase("QSQLITE");
- db.setDatabaseName("sql.db");
- QSqlQuery query;
- query.exec("create table student(id int primary key,name varchar(20))");
- QTime *timer=new QTime;
- timer->start();
- if(query.at()<100000){
- db.transaction(); //开始一个事务
- query.prepare("insert into student values(?,?)");
- QVariantList uid,uname;
- for(int i=1;i<100000;i++)
- {
- uid<<i;
- uname<<QString("%1").arg(qrand());
- }
- qDebug()<<"ready!now";
- query.addBindValue(uid);
- query.addBindValue(uname);
- query.execBatch();
- db.commit(); //提交
- }
- qDebug()<<timer->elapsed();
复制代码 |
|