Avaiga / taipy-core

A Python library to build powerful and customized data-driven back-end applications.
Apache License 2.0
38 stars 17 forks source link

Filter database datanode should not read all data #815

Closed trgiangdo closed 11 months ago

trgiangdo commented 1 year ago

What would that feature address

The current steps to filter a data node:

  1. Read all data from the data node
  2. Apply the conditions and return the filtered data.

For a data node that uses an indexed database (SQL, Mongo), “read all data” will not be able to take advantage of the queries when reading data.

Description of the ideal solution For indexed database data nodes, the conditions should be integrated into the read query, taking advantage of the query speed of the database.