This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to conform data from tables across several databases and am having real problems with one of the databases being really slow. All of the other data sources work fine and the database in question is fine when I test it with a different tool (for example SQL Developer or some Java I wrote). However, for some unknown reason Alteryx reads it really slowly, around 4 seconds per record. I need ~100,00 records which at the current rate would take around five days to read!
The database is Oracle and I'm not doing any fancy joins or manipulation in SQL which could (possibly) slow it down. I have tried running this In-DB but it makes no difference. I have also tried changing the Default Dedicated Sort/Join Memory Usage but to no avail.
As I have said, it works fine outside of Alteryx so can anyone think of a reason why it could be so slow?
@jonesds - most of the time performance issues on databases are driver-related, especially if you are seeing no speed improvement by using the in-db tools. Which driver/driver version are you using? In general, OCI is preferred for speed and performance.
Sophia Fraticelli Premium Support Advisor Alteryx, Inc.