How to optimize datasets in Domo a while importing a huge (30 columns/10 Million rows) database?
Options
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.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 557 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 571 Beast Mode
- 11 App Studio
- 28 Variables
- 579 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 352 Distribute
- 92 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 88 Community Announcements
- 4.8K Archive