QSqlTableModel slow fetch results



  • I found that QSqlTableModel is very slow when there is network delay. I use ms sql server and I found that after QSqlTableModel select() method is executed. I get all the data(the dataset is very small only 100 lines) I want. But if I get the value by row I found that it keeps on fetch from database which make the software very slow. If anyone have suggestion for this. Thanks



  • By the way if I use QSqlQuery and setForwardOnly. it is very fast. How can I fix this because QSqlTableModel is very convenient to a QTableView



  • I also found that in sql server profiler. If you get data from the model there will be sp_cursorfectch in the log. Why?? I think maybe qsqltablemodel is just useful in locat db like qsqlite. Has any one use qsqltablemodel with sql server??


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.