I installed InfiniDB with single UM and PM in one box, created three tables and tried to load data to each table ( 500 K rows, each row has ~50 columns ). When I run cpimport it took ~12 seconds to load data to a single table, since the machine has 8 cores I started running the 3 instances of cpimport with each cpimport loading data to different table. I see the time it took to complete each job is ~36 seconds. Is there a sequential access happening while loading data to different tables ? apart from changing/adding hardware is there any other way to increase performance through software ?
Options with which I am running cpimport are
cpimport -r8 -w12 -b13 -s, test table1 table1data.csv
cpimport -r8 -w12 -b13 -s, test table2 table2data.csv
cpimport -r8 -w12 -b13 -s, test table3 table3data.csv
Thanks for your help.