Optimizing Data Retrieval and Processing in Knime

Hello everyone, seeking advice on optimizing data retrieval and processing in Knime. Should I filter data within Knime after fetching from the database, or filter directly in the query? Additionally, for operations like GROUP BY and averaging, is it better to perform them in Knime or in the database itself? Your insights and experiences are much appreciated!