How to speed up data insertions from MATLAB to Vertica database

1 view (last 30 days)
Hariprasad
Hariprasad on 19 Feb 2016
In my project, I have to insert/update millions of records in batches to Vertica database. Currently I'm using datainsert function to insert 3000 records at a time and it takes about 6 seconds for each insert which is too slow when there is a situation of even inserting 1 million or more records. Are there any faster ways to do the insertion from Matlab to Vertica database?

Sign in to answer this question.

Answers (0)

Categories

Find more on Database Toolbox in Help Center and File Exchange

Tags

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!