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,
OCI
@geraldo it is OCI. Any ideas?