MYSQL Time

Hi,
Is there a way to cut down the time of MYSQL dataflows?
I have a dataflow that takes 6 hours for 5 million rows of data and would love to find a way to cut that down.
Best Answer
-
You can try and implement indexes in your MySQL dataflow however I'd HIGHLY recommend rewriting your MySQL dataflow in Magic ETL as MySQL is sequential (it has to wait for each dataset load or step to complete before it can move to the next one) compared to Magic's sequential processing (can do many steps simultaneously).
I've seen improvements of over 90% when converting MySQL to Magic ETL.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
You can try and implement indexes in your MySQL dataflow however I'd HIGHLY recommend rewriting your MySQL dataflow in Magic ETL as MySQL is sequential (it has to wait for each dataset load or step to complete before it can move to the next one) compared to Magic's sequential processing (can do many steps simultaneously).
I've seen improvements of over 90% when converting MySQL to Magic ETL.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
I will give that a try, thank you.
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 86 Workflows
- 23 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 117 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive