Speed up the execution of query activity | Community
Skip to main content
El-Coder
El-Coder
Level 2
January 27, 2021
Solved

Speed up the execution of query activity

  • January 27, 2021
  • 3 replies
  • 1370 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by keertij82676895

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

3 replies

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe Employee
Adobe Employee
January 27, 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

 

    keertij82676895
    keertij82676895Accepted solution
    Level 2
    January 29, 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

      Sukrity_Wadhwa
      Community Manager
      Sukrity_WadhwaCommunity Manager
      Community Manager
      February 15, 2021
      Hi @el-coder, Was any of the given solutions helpful to resolve your query? Do let us know. Thanks!
      Sukrity Wadhwa
      Terms & ConditionsAccessibility statement

      Loading footer...