X++ Code Optimzation performance tuning

X++ Code Optimzation
Following are the coding tips to improve your Axapta system's performance:
1. Smart Joins : Try to Use Joins instead of nested while loop
wherever possible.
2. Select Statement : Mention the field names in the select statement
instead of feteching entire row , this will reduce
data amount to transfer from database.
e.g " Select Itemid from inventTable "

3. Display Methods : Make sure that generic display methods should be
moved at table level and cached by
using"Formdatasource.cacheAddmethod".
4. Local caching : Use Variables for storing the constantly used
caculated values in loop , by doing so you can
reduce the calls to the database and different
layers.
5. Monitor the Database Calls : For bulk records
updation,deletion,insertion use
RecordSet Based operator like
update_recordset , delete_from and insert_recordset .
6. Aggregate Function: Use sum, avg, minof, maxof and count where
applicable. Because this can utilize the database’s
built-in function instead of calculating and analyse
data in Axapta.

AIF Custom service atributes in AX

SysEntryPointAttribute:This is a mandatory attribute in methods that
are exposed as a service operation. It indicates
that the method is a service operation. Not
using this attribute will result in a service
group deployment failure.
An optional parameter specifies whether the
AOSAutorization setting on the tables will
be checked when this method is executed on
the server.
Ex:
[SysEntryPointAttribute(true)]
private void GetRecord(Str _titleId)
{
}
DataContractAttribute:Defines that the attributed class is used as a
data contract for a service.
Ex:
[DataContractAttribute]
private void GetRecord(Str _titleId)
{
}
DataMemberAttribute:Indicates that a parameter method is a data
member in a data contract for a service.
Ex:
[DataMemberAttribute]
private void GetRecord(Str _titleId)
{
}

AifCollectionTypeAttribute:This attributes specifies the type that is used
in a collection. It contains the name of the
parameter that is targeted and the types of the
objects that are contained in the collection.
Ex:
[AifCollectionTypeAttribute]
private void GetRecord(Str _titleId)
{
}

Get Customer name and Vendor name in display method in 2012

Hi Friends,

Str name;

//Customer name
name = DirPartyTable::getName(CustTable.Party);

// Vendor Name
name = DirPartyTable::getName(VendTable.Party);

above peace of code can use in display method.

Multiple (Auto + Manual) Number Sequences in AX 2009

Multiple (Auto + Manual) Number Sequences in AX 2009

Click here

Event Handling in Microsoft Dynamics AX 2012

Event Handling in Microsoft Dynamics AX 2012

Hi Friends this will be help for you as Event handling is very important concept in AX 2012
please click here

Thanks
Happy
Daxing

Data Migration Framework within Microsoft Dynamics AX 2012

Data Migration Framework within Microsoft Dynamics AX 2012

TFS - Team foundation Server

click here TFS - Team foundation Server

Click here for video