Thursday, December 2, 2010

Pack/Unpack Mechanism to reduce the RPC Count for Temporary Table


Many a times it’s becomes our need to use the temporary tables while displaying data either on the forms or dialog forms. We all are aware of how to use temp table in AX and also with this fact that there is always being a performance impact (chattiness between client & server) to insert data in temp table.
We can use pack/unpack mechanism to reduce this chattiness and pack the whole temp table data once on client and use it on the server.
You can use this mechanism like below,
Create a temporary table like in my case I created it with name “ProjTmpBudgetDisplay”
Create a class like in my case I created it with name “ClassTmpBudgetDisplay”


Create a form and override its init() method