In my project we are thinking to use Springbatch with JPA. Is it give any performance impact compare with Springbatch with JDBC? Most of my jobs are DB to File Job.Is anybody have any suggestions ?
Junior Member
SprtinBatch With JPA
In my project we are thinking to use Springbatch with JPA. Is it give any performance impact compare with Springbatch with JDBC? Most of my jobs are DB to File Job.Is anybody have any suggestions ?
Member
Rathan Prakash,
We are using JDBC. Initially we thought of using JPA wth Hibernate engine. Theoritically this combination should consume more time than using direct JDBC. Hence we went with JDBC.
Please note we did not do any benchmarking to analyse the performance difference. In case you run any performance comparison, please do share your findings.
Junior Member
Hi,
We have tried in our previous project with JDBC. In this we realized for processing 4.5 millions of record it is taking 35 minutes(DB to File Job) , i am expecting the same performance if i use JPA also . Is it possible to get ? If anyone have any suggestions please share with us.
Member
Rathan Prakash,Originally Posted by rathanprakash
The performance number you have given is very high (more than 2000 transactions per second). How do you read the data from DB? Did you use BULK READ or read individaul rows using cursor/resultset? Was there any processing of read data? While writing to file did you use Java's NIO or any special APIs?
Finally, Is your JDBC application a single threaded or multi threaded application?
Posting Permissions
Reply With Quote