baray98
24th September 2009, 00: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,
baray98
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,
baray98