How to optimize datasets in Domo a while importing a huge (30 columns/10 Million rows) database?
AritraChaudhuri
Member
in Archive
How to optimize datasets in Domo a while importing a huge (30 columns/10 Million rows) database from
1. Progress (Openedge Database)
2. Oracle
3. PostgreSQL (ETL)
0
Comments
-
0
-
@AritraChaudhuri We really need more information. Are you using Workbench to upload the data or are you using direct connections? You mention optimization so I assume that you have a slow down that you are trying to overcome, is that happening on import or is there an issue in some transformation? How often are you uploading this data? Is the data being uploaded using a replace or an append update method?
If we can get more insight into what you are doing and what your end goal is then we can provide better options for optimization.
Thanks for being part of the Dojo.
0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 555 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 568 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive