Performance: Input (green components) with In-DB (blue)

slickshoes

I have a process that uses green components with some blue (In-DB) throughout.

And was wondering if there is any performance gain with using all "green" components?

*Seems like there would the conversion components would take extra time/resources...

cheers,

CharlieS

Hi @slickshoes 

You are correct in that there is a performance cost to streaming the data back and fourth from the In-DB tools. The standard Input (green) vs In-DB (blue) will depend on several variables including what you need to do, resource availability, permissions, and so on.

In-Database (blue):

- The user must have write privileges on that database because these tools write temporary tables. 

- It's common for a database host to have a larger pool of computing resources compared to your local computer. Using In-DB tools will perform a majority of the processing on the database, which is often faster.

Input (green. in local Designer):

- Old reliable. 

If you can share more information about what you're doing, I'm sure the Community could share more thoughts on the matter.