QSqlTableModel o QSqlQueryModel
-
hi all:
My question is simple, with which class best fits and performs better, for example-Al sql query.
A built-in row or column QcheckBox, ComboBox, QPushButton and others.
And when there is a relationship between tables in a database.
It is better or Create my StandardModel.
What is the most profecial
(QSqltableModel or QSqlQueryModel). -
Which one fits best, depends on your use case. And you are telling us nothing about what you want to achieve.
-
The usual answer with that much information would be: It depends.
In particular:
- the number of columns
- the number of rows
- how the user is supposed to interact with the data
and possibly many more points.
-
Hello
If the forum I saw many problems using QSqlTableModel in queries, using setFilter () sql limiting, a comparison of the method QsqlQueryModel setQuery () solve this problem, but not well integrated QSqlQueryModel to sort data in QTableView sortingEnabled to order the sql query (producModel-> QSqlQueryModel :: setQuery (QString ("Select * From product where (product.id =% 1) limit 200"). arg (id)) ;) vanishes, well this is just some , what would be the best optionManagement System For Cars (desktop).
-With a large amount of data (200000 users).
-DB-Connection (Postgres).
-Ease of use.