Forum Discussion

AaronB's avatar
AaronB
Qrew Trainee
2 years ago

Pipeline error: Formula Query Execution took too long

I found some posts similar to this regarding reports but none for Pipelines so here is my situation.  I've also run the Performance Analyzer, Performance Insights, and Performance Optimizer but not h...
MarceloBenavide's avatar
MarceloBenavide
Qrew Cadet
2 years ago

 are you using a do-loop to loop through the 4k records and make changes to each of the 20 fields in each iteration?



------------------------------
Marcelo Benavides
------------------------------
ChayceDuncan's avatar
ChayceDuncan
Qrew Captain
2 years ago

If possible instead of doing any kind of loop you should just make a table to table import to move your fields inbetween your different subsets and have a pipeline run the import. It'll be more effiicient that way



------------------------------
Chayce Duncan
------------------------------