you can terminate the thread, but QSqlQuery .exec continue runing.
you can terminate the thread, but QSqlQuery .exec continue runing.
Does the database you are working with support paging?
If yes you could probably execute your query in smaller pieces.
Cheers,
_
Don't forget to thoroughly investigate why your single query is taking minutes, where that time is being spent, and redesign or adapt the query and database to perform better. Better joins, better indexes, temporary tables are all candidates you investigate.
Bookmarks