SQL slow query - table update

[gboelter]

It works nice but sometimes I have slow query (30-60s, there are few milion rows in database) and I want to update table during query to show partial result.

What about MySql's 'slow query log'?

http://dev.mysql.com/doc/refman/5.1/...query-log.html

[lasher]

Hi,

Thx for reply, but I don't use MySQL, I use PostgrSQL, this query log consists only slow query statements.

I want to update QTableView with QSqlQueryModel, when I execute query (setQuery())
I have to wait till end of this query to get result (sometimes more than 30s), so I want to refresh QTableView (let say every second) and get partial result updated every second till final end of my query.

Greetings!