Dynamic Input Tool slow
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a routine that uses Dynamic input to modify an SQL query (Replace Specific String) and bring the data from an instance we have at the office however it seems to be very slow.
I am trying to figure out whether or not it makes sense that the dynamic tool is so slow. It takes about 3 minutes to bring in 1.2k records with 32 fields and the dynamic tool takes about 98% of the total routine run time both on Designer and Gallery.
We rebuilt the instance indexes to make sure it wasn't the query that was delaying it, and also run the query from the MSSMS installed on Gallery to check for network related issues. Neither appear to be the case !
I realise that i am nitpicking here however the records will eventually grow exponentially and this routine is part of an automation platform we are building. The question here basically is that is this a normal behaviour for the tool? Any other troubleshooting steps i can try ?
Thank you for your time and looking forward for your suggestions !
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Constantinosch, if you copy that query and insert on a Data Input tool, do you see the same time to be processed as the Dynamic Input? If so, I'd say that the issue is the connection between Alteryx and your database server.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello!
Thanks for the reply, after checking with the Data input it was also running slow so we went back to the database. And you were right ! It seems our supplier didn't create any indexes!
Thank you very much for your reply
