Form loading takes longer time

(0) Share

Report

Posted on by Community Member

Hi All,

I am facing a issue with the Newly created form. Form is having so many display methods and using containers.

When I try to open the form with System Administrator Role it gets loaded within 5 secs and when I try to load this from role other other System Administrator Role it takes almost 2 minutes to load.

I know the when there are display methods on the form performance gets low but it should be applicable to System Administrator role as well.

Any suggestions on this?

Regards,
Tarun Lekhwani

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Rustem Galiamov 8,072 on at

Like (0)

Report

RE: Form loading takes longer time

Hi, Tarun!

Try to use Trace Parser for resolve this issue because other role may use more ranges than System Administrator role.

Was this reply helpful? Yes No
André Arnaud de Cal... 299,576 Super User 2025 Season 2 on at

Like (0)

Report

RE: Form loading takes longer time

Hi Tarun,

Are you caching the display methods on the form? What exact data is being retrieved? Verify if there are missing indexes or possibly also some security policies (XDS) involved. Do you have caching enabled on the tables used at the form data source or display methods? If so, what tables are used here? Using the Trace Parser, but also SQL performance monitoring and AXperf, you can try to find the culprit if there are no obvious reasons.

Was this reply helpful? Yes No
Suggested answer

Hossein.K 6,648 on at

Like (0)

Report
RE: Form loading takes longer time

Hi,

Clear cache of system:

static void RefreshLocalCache(Args _args) { xSession::removeAOC(); SysTreeNode::refreshAll(); SysFlushDictionary::main(null); SysFlushAOD::main(null); SysFlushData::main(null); SysBPCheckAIFDataObject::flushCache(true); SysFlushReportServer::main(null); SysFlushSystemSequence::main(null); xSession::updateAOC(); }

Was this reply helpful? Yes No
Suggested answer

Hossein.K 6,648 on at

Like (0)

Report

RE: Form loading takes longer time

Hi,

Check this link:

community.dynamics.com/.../87286

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

RE: Form loading takes longer time

Used trace parser found one query on the display method which is taking longer execution time.

Was this reply helpful? Yes No
PA-22040759-0 6,194 on at

Like (0)

Report

RE: Form loading takes longer time

You should make sure that the query part of this runs on the server tier on not directly on the client tier. So from the display method, call a server bound method to do the actual work.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Form loading takes longer time

Hi,

Could you please explain this in detail.

Thanks in advance

Was this reply helpful? Yes No