Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » How to configure batch-writing parameter for sybase
How to configure batch-writing parameter for sybase [message #645056] Wed, 15 December 2010 07:43 Go to previous message
ash is currently offline ash
Messages: 142
Registered: July 2010
Senior Member
Hi,

In our application we have a requirement to insert huge data to Sybase database (upto 5 lakhs of records). We are using JPA + Eclipselink.

I optimizing the code to improve the performance and came across the method batch-writing.

In a MySql server to persist 10k records as a batch it take 3.9 seconds and the same 10k records takes around 45 seconds in Sybase by using batch-writing.

I tried all the options to configure batch-writing in persistence.xml i.e "JDBC" and "Buffered". In this JDBC gives a good performance comparitively to Buffered while persisting in MySql server but its still same with Sybase.

Please help me out how do I optimize or tune to achive the same in Sybase server. (from 45 seconds to 4 sec)

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Previous Topic:Running CanonicalModelProcessor in maven causes 100% CPU usage
Next Topic:execute update
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 19 05:09:54 EDT 2013

Powered by FUDForum. Page generated in 0.01777 seconds