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.
In my Input tool, I am just doing Select * from <table_name>
The same query if I run in SQL server side it takes only 5 minutes to load records
But in Alteryx it takes more than an hour to do it. I am just curious to know if we can do it faster loading or any other alternative or any other tool should I use in alteryx. If you can provide steps would be great help
Remember that Alteryx reads and processes the data differently to SQL Server. When you run the query in SQL Server it's pulling back all the records at once. When you run the same query in Alteryx, it processes 1 record at a time.
You did mention using inDB tools though. Where are you using those tools ? Where does the workflow output to ?