Geeks With Blogs
SAM|NET »»» technology + aesthetics «««
http://msdn.microsoft.com/en-us/library/bb314749(AX.10).aspx

Temporary Tables vs. Containers

Microsoft Dynamics AX supports a special data type called a container. This data type can be used just as you would use a temporary table. For more information, see Containers.

Data in containers are stored and retrieved sequentially, but a temporary table enables you to define indexes to speed up data retrieval. Containers provide slower data access if you are working with many records. However, if you are working with only a few records, use a container.

Another important difference between temporary tables and containers is how they are used in method calls. When you pass a temporary table into a method call, it is passed by reference. Containers are passed by value. When a variable is passed by reference, only a pointer to the object is passed into the method. When a variable is passed by value, a new copy of the variable is passed into the method. If the computer has a limited amount of memory, it might start swapping memory to disk, slowing down application execution. When you pass a variable into a method, a temporary table may provide better performance than a container.

 

1.1       Temporary Tables and context

Using temporary tables as the primary data source in EP page posse a number of technical limitations. The most significant being the lack of context.

1.1.1       Problem Description

Context is not maintained on temporary tables hence the web part that contains it cannot be used as a provider to other webparts like the toolbar webpart which is connected to the current context of the provider view. The flow of activities in the process is hindered since additional processing needs to be done to pass the context explicitly to the caller. Temporary tables cannot be used as the source of a lookup control either.

RELATED POST : Setting Session Timeout for Dynamcis AX EP

http://www.odetocode.com/Articles/450.aspx

http://geekswithblogs.net/vivek/archive/2006/10/04/93094.aspx

http://msdn.microsoft.com/en-us/library/ee330228.aspx

http://msdn.microsoft.com/en-us/library/ee330227.aspx

Posted on Thursday, July 16, 2009 5:26 PM | Back to top


Comments on this post: DAX 2009: Temporary Tables in Enterprise Portal

# re: DAX 2009: Temporary Tables in Enterprise Portal
Requesting Gravatar...
I prefer a well programmed and constructed mix cd with tracks i may know already but barely hearedeveryday before a typical jadajada mix cd with some not released stuff here and there but where everytrack is fulfilling some genres stereotypes and the rest is overplayed beatport top10 material…
Left by gioca ai casinò di internet on Apr 01, 2010 5:31 PM

# re: DAX 2009: Temporary Tables in Enterprise Portal
Requesting Gravatar...
Oh.. so temporary tables are better than containers? Will keep that in mind.
Left by Central Heating on May 10, 2010 12:35 AM

# re: DAX 2009: Temporary Tables in Enterprise Portal
Requesting Gravatar...
The tutorial is very simple and explained to a great level. It doesn’t take any effort from our side to grasp it! I guess now I understand what the threshold function was for and how it could be used to make striking line art conversion effects!
Left by motorcycle games on Mar 02, 2011 7:48 AM

# re: DAX 2009: Temporary Tables in Enterprise Portal
Requesting Gravatar...
I’m happy to have found your very excellent article! I agree with some of your readers and will eagerly look forward to your coming updates. Just saying thanks will not just be adequate
Left by novelty diploma on Mar 02, 2011 8:26 PM

# re: DAX 2009: Temporary Tables in Enterprise Portal
Requesting Gravatar...
This is a great blog with excellent posts and links.
Thanks for sharing.
Left by send flowers in germany on Mar 11, 2011 5:05 PM

Your comment:
 (will show your gravatar)


Copyright © Prabhat Samuel | Powered by: GeeksWithBlogs.net