Look performance between schedule and adhoc execution

[a_shah]

Hi All,

We are experiencing difference between performance of Looks between the execution based on a schedule and adhoc execution. Ignoring the variance in BQ slots availability, is there any other aspect that can cause this behavior?

[dsimeonova · Accepted solution]

Hey @a_shah !

The schedule runtime sometimes can be longer as there are several queries or schedules at the same time. Did you check if there are several tasks running at the same time? Another reason can be if the schedule runtime is usually on your peak hours. I would suggest this to check as well.

Please share your insights.

Good luck!!