You are viewing limited content. For full access, please sign in.

Question

Question - Will having multiple LookupRules cause excess latency on a form?

Forms

Updated October 4, 2018

asked on October 4, 2018 • Show version history

The scenario right now is that a particular Form with more than 20 LookupRules and over 50 FieldRules is a bit slow to load. For some users, it would take about 3-5 seconds to load the landing page without any data entered to trigger these LookupRules.

My question has to deal with whether a form loads all the Lookuprules on pageload and would reducing some of these rules decrease latency?

0 0

Replies

replied on October 4, 2018

Hi Paul, yes, the number of queries can cause latency, but this is also driven by the SQL servers ability to handle the load. SQL Express only utilizes 1 Core and 1 Gig Ram so the number of queries will slow things down. You can put more horespower behind SQL standard by adding more Cores and Ram, but there are licensing cost to adding cores. If you can perform less queries by using Stored Procedures this can be more efficient and reduce the load.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked October 4, 2018
Updated October 4, 2018
40 views