We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

What is the relationship between alteryx and "commitment" to a Database?

dgaines1972
7 - Meteor

I have a workflow that writes a single record to an oracle database.  This is about 6 seconds.  Within oracle, an internal procedure is triggered by this record having been added.  It takes about 20 min for this procedure to complete within Oracle.   I am finding that the alteryx workflow then continues to clock until that internal procedure within the database has completed.  This causes the overall run time to include that extra 20 min.  

 

Q1-Why does this happen?  

Q2-Is there anything I can do to make the Alteryx faster, or clock only the actual 6 seconds?

 

Thanks,

3 REPLIES 3
geraldo
13 - Pulsar

@dgaines1972 

 


Do you use InDB or InOut tools?

OCI connection?

dgaines1972
7 - Meteor

OCI

dgaines1972
7 - Meteor

@geraldo it is OCI.  Any ideas?

Labels
Top Solution Authors