QStandardItemModel插入数据很慢,达到2000条就很慢了,怎么改进啊?
void Global_all::getTab(MyTableWidget *tab,int currentIndex){
currentWidget=tab;
QSqlQuery query;
sql=this->setSql(currentIndex,GlobalVariables::check_hidden[currentIndex]);
qWarning(sql.toLatin1().data());
QModelIndex top ;
currentWidget->model->removeRows(0, currentWidget->model->rowCount(top), top);//清除原有的model数据
if(query.exec(sql)){
while(query.next()){
currentWidget->model->appendRow(new QStandardItem("vector")); //便于让大家看清代码new QStandardItem("vector")是我特意设置插入的值,源代码是将执行sql语句后获得的记录进行插入
}
}
else // 如果查询失败
{
//QSqlError error = query.lastError();
QMessageBox::information(NULL,"提示","数据库查询失败",QMessageBox::Yes,QMessageBox::Yes);
}
}