[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1598
  • Last Modified:

jConnect bulk instert

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 ?
0
Jan Franek
Asked:
Jan Franek
1 Solution
 
objectsCommented:
think you'll find its a limitation of jdbc. The extra layers involved with jdbc make it unable to match the performance of more native tools.
0
 
for_yanCommented:
I notice the same thing with Oracle, though not that dramatic

I also think that even if you are running it all on the server jdbc's design assumes
network interactions and this also causes slowdown.
 
0
 
alpmoonCommented:
The huge difference might be because of batch size. I don't know how it works with Java, but the actual batch size might be too small to make the speed comparable with bcp.
0
 
Jan FranekAuthor Commented:
Batch size doesn't matter - bcp utility is still 10x faster, even with the same batch size.

OK, thank for input, but it's only general information without any useful specific experience with my situation. So I'll ask EE to close the question.
0
 
Jan FranekAuthor Commented:
No useful information.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now