QSqlTableModel o QSqlQueryModel
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.
- the number of columns
- the number of rows
- how the user is supposed to interact with the data
and possibly many more points.
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 option
Management System For Cars (desktop).
-With a large amount of data (200000 users).
-Ease of use.