View Full Version : a faster QSqlQueryModel::data()

24th September 2009, 01:56
I am using QSqlQueryModel for my QTableView and I found that fetching data from database is not bad timewise since i ask my model to fetch them all to begin with.

somewhere in the life of my model i ask all row's data with,QSqlQueryModel::data() , and find that this is the slow part in my application.

I am asking your opinion on how to somehow bypass this process and get to my needed data in a fast manner, I am only using Qt::DisplayRole part. My current Rate is about 30000 rows per second with 100 000 rows in the model

Any suggestion is appreciated,