jConnect bulk instert
Posted on 2011-05-09
We are trying to insert some data into Sybase ASE (15.0.3) using java application (jConnect 7.0). We would like to use bulk insert, so we set ENABLE_BULK_LOAD and use prepared insert statements and batch updates.
We have reached approximately 10x faster inserts when compared with normal inserts without bulk load and batch updates. But it is still 10x slower than using bcp utility. Tested on the same system, with the same data and tables without indexes.
Is this the limit for jConnect bulk load ? Or did you succeed to reach the same speed as bcp utility ?