How to speed up data insertions from MATLAB to Vertica database
1 view (last 30 days)
Show older comments
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?
0 Comments
Answers (0)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!