Question

Dúvida Performance

0

Olá comunidade. Sou novo em desenvolvimento Mendix e me surgiu uma dúvida relacionada a performance. Garante uma maior performance para a aplicação: realizar apenas 1 Retrieve e utilizar a funcionalidade List Operation para filtrar de formas diferentes os dados recuperados ou realizar diferentes Retrieve's já filtrando via XPath ?

asked 2024-07-25

Rafael Ponzoni

2 answers

2

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

answered 2024-07-26

Fadel Damen

Kamalanathan S · Accepted Answer · 2024-07-26

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!