Troubleshooting in Creator #3: Deluge execution limit optimization

Dear developers,

A Deluge statement execution corresponds to each line of code executed within a certain script. The total number of lines executed to complete a certain task on an action like on success is associated with a Deluge execution limit in Creator. To ensure good performance and usability, the number of lines of code executed at a time should be optimized.

Apart from each line of code written under an action, Deluge executions depends on factors such as the use of certain tasks, loops, and functions.

For example, if you're running a for each statement for a form which has 100 records in it, and you have 5 lines of code within the for each, the total number of Deluge statements executed will be 500.

If you have a function call inside the workflow, the number of lines of code in the function will also add up to the Deluge execution limit.

In this post, we'll discuss some simple scripting practices and ways to optimize code executions in Deluge:

Case 1: Using for each tasks

Case 2: Reducing variable definition to store fetched data

Case 3: Avoiding multiple IF statements and using ELSE IF

Case 4: Using built-in functions instead of counter variables

Ways to optimize execution

Case 1: Using for each task

While using for each tasks, we can utilize criteria to control the records through which it iterates.

Example:

for each rec in Form_Name[ID!=0 ] // this will iterate all the records in the form
{
....
}

Instead, try the below script:

for each rec in Form_Name[field_name=value && field_name2=value2] // this will only be executed for records that satisfy the given criteria
{
....
}

To iterate through records within a specified range, which meet a criteria, follow the below syntax:

for each rec in Form_Name[<criteria>] range from <start_index> to <end_index>;

Case 2: Reducing variable definition to store fetched data

In some cases, we assign fetched values to a variable and use that variable within the script. If this assignment is done within a for each task, it can increase the Deluge execution. Therefore, instead of this assignment, we can directly use the fetched data in the workflow.

For example:

fet=form[criteria];
a=fet.field1;
b=fet.field2;
input.total=a+b;

Instead, try:

fet=form[criteria];
input.total=fet.field1+fet.field2;

Case 3: Avoiding multiple IF statements and using ELSE IF

When you need to execute a task based on multiple conditional statements, using else if statements can help avoid extra lines of code execution.

For example:

if(a==1)
{
...
....
}
if(a==2)
{
..
...
}
if(a==3)
{
..
...
}

Instead, use:

if(a==1)
{
..
...
}
else if(a==2)
{
..
}
else
{
..
...
}

Case 4: Using built-in functions instead of counter variables

Suppose we need to get a sum/count of data for a particular field for a set of records. It's usually done by using a counter variable, as shown below:

ctr=0;
for each rec in Form_name[criteria]
{
ctr=ctr+1;
}
info ctr;

Instead of the above script, we can use our built-in function, count(), as shown below:

1.fet=form_name[criteria].count(ID);info fet;

Note: The count function in the aggregate records Deluge task returns the count of values (including empty strings) a specified field holds, from records fetched using a criteria.

Now imagine we have to use the record count inside an if statement to execute a particular task, then usually the script used would look something like this:

var=Formname[x=y && z=t];
Var2=var.count(ID);
if(var2>0)
{
..
...
}

This can be optimized to:

If (Formname[x=y && z=t].count(ID)>0)
{
..
...
}

And we hope that helped! You can find more information about our built-in functions in this help article.

Please let us know how you like this article in the comments below, as well as any other topics you'd like to see us work on. Contact support@zohocreator.com for any further questions.

New to Zoho LandingPage?

Access Zoho LandingPage

Zoho LandingPage Resources

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Tout forum

France ZUGs

Zoho SalesIQ Resources

Topic Participants
Vishnu Suresh

Sticky Posts
[SESSION ENDED] Ask the Experts #07| Live Q&A: Building workflows with Blueprint in Zoho Creator |
Hello, Post the release of Zoho Creator Blueprint last month, we're happy to tell you that we'll be launching a new 'Ask the Experts' session on 16th September (Thursday) this month focussing on creating blueprints in Zoho Creator. The session will be
Zoho Creator Community Webinars | October - November 2020 [Completed]
Hello everyone, I’m happy to announce that Zoho Creator is hosting a new Community Webinar Series starting this October. This series is a learning initiative aimed at our developer community, where every session will take spotlight use cases focused on
Community Learning Webinar - Zoho Creator Blueprint & other release updates | July 29, 2021
Dear developers, This June, the Creator team unveiled a slew of updates including UI enhancements to the Detail View of reports, an new capabilities in Data Import and Connections, and most important of all, the release of Blueprint in Creator. Customize
Community Learning Webinar: Delve deep into the core concepts of Zoho Creator | 17th June, 2021
Dear developers, Every customer has unique business needs and unique problems to solve. To be able to give solutions to these problems, to get over any stumbling blocks and to be able to build applications expeditiously that tailor to specific needs,
[RECORDING: Community Webinar] | Build complex reports and documents with a Zoho Creator & Zoho Writer integration | March 23, 2021
Dear developers, Report generation is an essential activity to ensure decision makers have the best information available to be able to monitor and improve performance. Enterprises may need to generate and distribute stakeholder specific documents in