Hi Rafael
In Mendix, for optimal performance, it is generally better to perform multiple retrieves with XPath filtering rather than a single retrieve followed by list operations, especially when dealing with large datasets. This approach leverages the database's efficiency in filtering, reduces memory usage, and typically results in faster query execution. However, for small to moderate datasets, a single retrieve with subsequent list operations can be efficient and simpler to manage. Ensure proper indexing and use Mendix’s performance monitoring tools to identify and address any bottlenecks. Also make sure you are not making the database retrieve inside a loop. Refer this link to know more about database retrieve Mendix Retrieve
Hope this helps!
Ola Rafael,
Apenas traduzindo o que o Kamalanathan falou, o melhor e fazer varios retrives com xpath, evitando usar os retrives em loops.
Outro pratica quando se trata de um volumen de dados grande mesmo com o filtros xpath e dividir o retrives em partes como este treinamento na academia exemplifica. https://academy.mendix.com/link/modules/21/lectures/204/3.1.1-Analyze-Microflow-Retrieves
sds