Performance optimizations for data operations

A method, comprising:

• determining, by a computer processor of a performance optimizer, a new type of data job to be executed, based on a job execution parameter, in connection with a data source and a data service tool;
• performing a first execution of the new type of data job, such that data operations are performed at the data service tool, and collecting first performance results;
• performing a second execution of the new type of data job, such that data operations are pushed down and performed at the data source, and collecting second performance results;
• comparing the first and second performance results;
• updating a result storage with a pushdown flag comprising an indication of whether subsequent executions of the new type of data job will perform data operations at the data service tool or at the data source;
• and
• in response to receiving a subsequent request for the new type of data job to be executed on a particular job execution parameter, performing a subsequent execution of the new type of data job such that the data operations are performed at the data service tool or are pushed down and performed at the data source, based on the pushdown flag in the result storage.

A non-transitory, machine-readable medium comprising instructions thereon that, when executed by a processor, cause the processor to execute operations to perform a method, the method comprising:

• determining, by a computer processor of a performance optimizer, a new type of data job to be executed, based on a job execution parameter, in connection with a data source and a data service tool;
• performing a first execution of the new type of data job, such that data operations are performed at the data service tool, and collecting first performance results;
• performing a second execution of the new type of data job, such that data operations are pushed down and performed at the data source, and collecting second performance results;
• comparing the first and second performance results;
• updating a result storage with a pushdown flag comprising an indication of whether subsequent executions of the new type of data job will perform data operations at the data service tool or at the data source;
• and
• in response to receiving a subsequent request for the new type of data job to be executed on a particular job execution parameter, performing a subsequent execution of the new type of data job such that the data operations are performed at the data service tool or are pushed down and performed at the data source, based on the pushdown flag in the result storage.