The query to the database is executed. Data is displayed in the grid. Can filter data. Where is it better to store the result of the query to the directory for further use?

  • one
    In what sense "where"? Depending on this, the answer is - in memory, in the model, in the collection of Entity-classes, ... - VladD
  • In the literal sense. So that the DB does not pull hundreds of extra times, where it is better to store the directory elements, so that later, without any problems, after filtering, display them on the form? - Alexander Puzanov
  • one
    In such a formulation of the question, in the class / ah model is unique. After launching, you read references from the database to the model and use them, unless of course the reference books can be changed by the user. - rdorn
  • These are still reference books, so reference data is subject to change. - Alexander Puzanov
  • If they can change, then you have to update them. If users can be more than one per unit of time, they will have to be updated each time the user accesses the directory. The exception is the user's personal directories, in which no one except him can make changes - rdorn

0