Slow loading of dropdown entries

(0) Share

Report

Posted on by Manuel Kern

Hello,

I have a problem with the Sales Order Details form. When I click the dropdown button of the Campaign ID in the General tab, the Campaign IDs from the smmCampaignTable are loaded as it is defined by the relation on the EDT. But since the smmCampaignTable Table has several thousand entries it takes about 20 seconds to load all entries. This is much too long.

Is there a way to speed this up or is it possible that the first entries are already shown while the last entries are still being loaded?

Best regards,

Manuel Kern

*This post is locked for comments

All responses (1)

Answers (0)

Sacha Kircev 905 on at

Like (0)

Report
Re: Slow loading of dropdown entries

Hi,

In your environment is there customizations on this lookup ?

Anyway, you can try to optimize this lookup by several methods :

Optimizing the x++ code that takes the most of the CPU time during the lookup (use code profiler
determine where the lookup spends most of the time), for example in standard AX 2009 5/6 of the
time is spent in the smmCampaignTree::createTree() static method.

Rewrite the lookup entirely, write one that don't build a Tree Control (which allows manipulating hierarchies)
but just selects the campaignId field of smmCampaignTable (using SysTableLookup).

Try optimize the indexes on smmCampaignTable
I think that in your case creating one unique index containing ParentCampaignId and Recid should
give better performances.

Regards