Data Loading Performance

Typical Issues:

  • Loads are too slow to keep up with analysis needs
  • Loading limited to nightly batch windows

Causes:

  • Inability of loading to scale
    • One node loading serially, instead of in parallel
  • Co-dependent processing
    • Queries and loading on same nodes
    • Query performance degrades or causes downtime
    • Your business cannot tolerate a query outage, delaying loading
  • Destination bottlenecks
    • One node receiving loads serially
    • Data is queued up and bottlenecked by disk write speed of single node
  • Network becomes a bottleneck
    • Too much data being loaded through a congested interconnect

Remedies:

Top Picks
Whitepaper: A New Approach for Large-Scale Data Management and Data Analysis
Whitepaper: Deriving Deep Insights from Large Datasets
Forrester Report: In-Database Analytics: The Heart of the Predictive Enterprise
With Aster nCluster ... our data load time has decreased by over 95 percent, and our most important queries complete in seconds or less.

ShareThis
Tim Schigel, CTO