Progress of SQL "select"

[brokensword]

Sorry, I can't understand your idea. Select() function is synchronous, it doesn't return until all data would be fetched. So where from should I call processEvents()?

Can you give some piece of example code?

[jacek]

Select() function is synchronous, it doesn't return until all data would be fetched.

I see we don't understand each other. Please define "progress of select statement".

[brokensword]

I have a QSqlTableModel. I fill it with data using setFilter() or select() methods of QSqlTableModel. Both are synchronous (they don't return until all records would be fetched). Operation can take more then 5 minutes.

Everything I need to know is just how much records were fetched so far.

I've tried to make static QSqlTableModel object, fill it with data in separate thread and call rowsCount() (query->size()) in loop in main thread. It doesn't helps - rowsCount() (and query->size)) return 0 until model would be fully filled.

So is there any way to get QSqlTableModel filling progress info?

[jacek]

Everything I need to know is just how much records were fetched so far.

I see, I thought you were using QSqlQuery.

You might try connecting to QAbstractItemModel::rowsInserted() signal.

[brokensword]

Didn't work. rowsInserted() signal is emmited only once - at the end of filling process.

I see, I thought you were using QSqlQuery.

You might try connecting to QAbstractItemModel::rowsInserted() signal.

[jacek]

Didn't work. rowsInserted() signal is emmited only once - at the end of filling process.

Too bad. I've checked the sources and it looks like QSqlTableModel (QSqlQueryModel actually) doesn't fetch the data row-by-row, but rather retrieves particular cells as needed in data() using QSqlQuery::seek().

Maybe you could create your own model that will load data using typical while( query.next() ) loop?