P
P
Pavel Stepantsov2020-05-16 13:53:09
Yii
Pavel Stepantsov, 2020-05-16 13:53:09

gridview. How to make a convenient selection of data from large tables while maintaining the intermediate result?

The question is general, I do not ask you to chew it to the smallest detail, please give at least a direction where to look ...
The task is a table with a large (from 1200) number of records. You need to select certain rows, but at the same time, rows can be selected using filters and you can ensure that any row that is not included in the current filter is added to the result. This set of records also needs to be saved to the database for use in other tasks.
How to solve such a problem correctly? Do you need to save sql queries or an array of selected id after each filtering? Or make an intermediate table in which the record id and list id will be recorded (too many records in the end .... lists of 20-50 items, about 1000 lists)
I could not find something similar ...

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question