InsertRecord performance in QSqlTableModel.

[zither]

Dear all,

@if (file.open(QIODevice::Readonly))
{
while (!file.atEnd()){
QString str = file.readLine();
QStringList strList = str.split("\t"); //parsing tab separated file
QSqlTableModel.insertRecord(0,makeRecord(strList)); //makeRecord returns QSqlRecord
}
}@

That cause serious performance problem. It takes 1 min to parse about 20K lines of file. What's wrong with that code?

Thanks

[dangelog]

No idea. Profile your program, switch to the manual submit strategy and call submitAll, consider using QSqlQuery inside ONE transaction, etc.

[zither]

Thanks for advice.

I already set manual submit. It just to add data to table & manual submitAll later.

I'll try with QSqlQuery to source Table..

[zither]

@peppe

I can't get it, QSqlQuery inside ONE transaction is worsen than insertion of table row...

How can I do that?

[ZapB]

Where does the profiler say most of the time is being spent?

Try using QSqlQuery directly rather than via the table model.