Reference variable is taking more time to load in record producer.

[Alok21]

Hi Team,

I have a variable (reference to table "customer_account") in record producer. When i am clicking on that variable its taking bit more time to fetch the data from the table.  Can someone please advise what could be the possible causes and how can we fix it?

Regards,

Alok sahu

[Barrilito van D]

Hi. When you refer to "slower" , slower then what?

In general it should work the same anywhere you use a reference field. As I don't know what your record producer looks like, you may do a test by making a record producer with only that one reference field, being sure nothing else in the form is slowing it down. If you did that, then perhaps use a reference qualifier on the field to filter down the results, perhaps it will make it faster.

Good luck!

[Alok21]

Hi,

Other than Prod environment, the variable is fetching data in 5-10 secs. But in Prod it is taking 20-30 secs and i would like to know what could be the issue.

Regards,

Alok sahu

[weikiat_guaz]

Are your reference field have a complicated Reference qualifier condition?

[Alok21]

Not that complicated. Calling script include and there is Gliderecord query to a table, checking if record exist and if yes one more condition check and pushing the data to the reference variable.