Alteryx Designer is slow when using In-DB tools.
We use Alteryx 2019.1 on Hive/HortonWords with the Simba ODBC Driver configured with SSL enabled.
Here is a compare In-DB / in Memory :
![demo01.gif demo01.gif](https://community.alteryx.com/t5/image/serverpage/image-id/89890i02AA842AA7A6C189/image-size/large?v=v2&px=999)
![demo02.gif demo02.gif](https://community.alteryx.com/t5/image/serverpage/image-id/89889i7BA69C145FC7CEFB/image-size/large?v=v2&px=999)
We found that Alteryx open a new connection for each action :
- First link to joiner = 1 connection.
- Second ling to joiner = 1 connection.
- Click on the canevas = 1 connection.
Each connection take about 2,5 sec... It really slow down the Designer :
![ScreenLog.jpg ScreenLog.jpg](https://community.alteryx.com/t5/image/serverpage/image-id/89892i6CD511367EB5D007/image-size/large?v=v2&px=999)
Please, keep alive the first connection instead of closing it and creating a new one for each action on the Designer.