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

No comments:

Post a Comment

I will appreciate your comments !

Download large bacpac (sandbox database) to DEV environment much faster

As the LCS website gets slower and slower and the database backups get bigger and bigger.  Use AZCopy to download objects out of LCS asset l...