Re: [eclipselink-users] Question About Writing to DB and performance

[James Sutherland <jamesssss@xxxxxxxxx>]

The user guide section on performance is probably your best place to start,

http://wiki.eclipse.org/Optimizing_the_EclipseLink_Application_(ELUG)

In general well optimized JPA will have some overhead over well optimized
JDBC, as it uses JDBC, but if you optimize things well, it should not be
large.  If your JDBC was not optimized, then since JPA is more configurable,
it may outperform your JDBC code.

The key things that effect insert performance:
- Ensure you use sequence preallocation, with a large preallocation size (do
not use IDENTITY sequencing).
- Ensure you use parameter binding and statement caching (EclipseLink binds
by default, you need to enable statement caching, either in your DataSource
or using EclipseLink's connection pool and persistence.xml property)
- Ensure you use batch writing (parameterized JDBC).
- Ensure you insert your objects in a batch, say 100-1000 per transaction,
use a different EntityManager per batch.
- Disable the cache for a batch insert, (shared=false)
- If possible avoid JTA or using a DataSource, just use EclipseLink
connection pooling, or JDBC driver level connection pooling as less
overhead.

There are a wealth of performance tests in the SVN repository for
EclipseLink, you could potentially use these to determine some metrics for
your system.


krisUSA123 wrote:
> 
> Hello Team,
>  
> I have a very intensive database writing application which is about to use
> JPA (with EclipseLink) rather than JDBC or SQL Loader. Are there any
> comparision metrics to see which ones is faster.
>  
> Also any links that can help me in improving the performance to write data
> to the database (Oracle 10g) using EclipseLink JPA. 
>  
> The Throughput is almost 4-5 million records per day. I have no
> validations to check for and mostly insert operations into one single
> target table.
>  
> Thanks in Advance!
> Kris
> 


-----
---
http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland 
http://www.eclipse.org/eclipselink/
 EclipseLink ,  http://www.oracle.com/technology/products/ias/toplink/
TopLink 
Wiki:  http://wiki.eclipse.org/EclipseLink EclipseLink , 
http://wiki.oracle.com/page/TopLink TopLink 
Forums:  http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink , 
http://www.nabble.com/EclipseLink-f26430.html EclipseLink 
Book:  http://en.wikibooks.org/wiki/Java_Persistence Java Persistence 
-- 
View this message in context: http://www.nabble.com/Question-About-Writing-to-DB-and-performance-tp21691924p21705712.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.