Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Speed up the execution of query activity

Avatar

Avatar
Validate 1
Level 1
El-Coder
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
El-Coder
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
El-Coder
Level 1

27-01-2021

What are the main recommendations for speeding up the execution of Query Activity?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 5
Level 2
keertij82676895
Level 2

Likes

5 likes

Total Posts

11 posts

Correct Reply

2 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Boost 5
Level 2
keertij82676895
Level 2

Likes

5 likes

Total Posts

11 posts

Correct Reply

2 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
keertij82676895
Level 2

28-01-2021

Hi,

 

As the Query recomputes every time usually it depends on the filters you are using on the data,

and if you really want to purge the data which already having some records and dont wants to recompute and fetch only the latest records we usually recommends to use Incremental Query.

 

Regards,

Keerti J

Answers (1)

Answers (1)

Avatar

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

167 likes

Total Posts

258 posts

Correct Reply

152 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

167 likes

Total Posts

258 posts

Correct Reply

152 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile
craigthonis
Employee

27-01-2021

Hello,

 

That really all depends on what the query is, how long it's running and the amount of data being pulled and the number of tables being joined.

 

In general, you want to query against indexed values, pull in only as much data as needed, if joining to other tables ensure that the fields being joined on are indexed. 

 

There are also a vast number of resources online that you can do a web search on that will give you best practices of querying a database so I'd recommend doing one of those.

 

Regards,

Craig