In-Database Data Stream Out and/or Browse In-DB tools causing flow to stall/freeze
- 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
Hi all,
I've had this issue a few times now on various Alteryx flows. They run fine in a few minutes at most, but as soon as I add a browse in-DB tool or a Data Stream Out tool, the flow slows to the point where it is completely unusable. I added a count of records and streamed that out and there were only 200 records, but it took 23 minutes to complete. Does anyone know a reason for this happening, and if there is any solution for it?
The data is coming from a SQL Server database.
Thanks in advance.
- Labels:
- In Database
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @domlewis15
it happened to a workflow i was builfing a few months ago and in my case the problem was the driver I was using.
I was connecting to SQL Server using ODBC driver and changed it to OLDB and it performs better.
Anyway, always you put a datastream out you load the data locally and it increments the time it takes to process. Try make just the count with the IN DB browser
I hope it helps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, was this issue ever resolved? Coming across the same issue here
