Hi all.
I have rather big database (20000 records with 17 columns each).
I use QSqlTableModel to display that base. However, when i try to scroll using scroll bar, my treeView lags (for about 1-2 seconds). Seems it lags when first time calling data() method to retrieve data from database. After fields are cached to view, i can scroll without any lags. How can i fix lagging for first call or at least precache data to view?
P.S.: same lags when using QueryModel
P.P.S.: also i have lag when model does fetchMore(), but it can be fixed by fetching all model.