[PyQt] Long SQL result slow QTableView

Linos info at linos.es
Mon Jan 19 16:42:21 GMT 2009


Hello,
	i have any queries that returns a somewhat large (not too much) number of rows 
(about 5000 with 7~8 columns), i am using now QSqlQueryModel in a QTableView, 
the problem it is the load at startup (and when i have to refresh the table for 
an update), i have thought to use a secondary thread to populate the list of the 
results in the background, should this work ok? maybe i am missing anything 
better integrated in qt?

About the changes in a sql querymodel result do i have any way to update only 
the row changed without have to make my own model caching the data and emiting 
dataChanged at finish? i would like qt would have a signal when the underlying 
sql data has been changed or anything alike.

Regards,
Miguel Angel.


More information about the PyQt mailing list