Alteryx workflow performance issues
- 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
Hello Experts.
I have a workflow to read few entries from SQL Server table, process the data using macro and write back to SQL Server table.
All these steps are taking ages to run. Can you please advise few tips to improve the performance.
Regards
S
- Labels:
- Database Connection
- Developer
- Server
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @narula8
If you haven't already try running the workflow with Performance Profiling enabled. That will at least give you an idea of where the bottlenecks are and which areas can be enhanced.
Another good option is to consider using the In-Database suite of tools rather than the standard, and shift all (or as much as possible) of the work over to the database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Check "Show All Macro Messages" when running Performance Profiling as well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
can you shed light on how big is your database and how many columns you have?
i've noticed significant performance decrease if the number of columns is 1,000+.
