Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Optimization for sequence ID
Optimization for sequence ID [message #1075549] Mon, 29 July 2013 16:12
F C is currently offline F CFriend
Messages: 12
Registered: June 2013
Junior Member
Hi, I have an entity with sequence ID like this

@Id
@Column(name="ID")
@GeneratedValue(strategy=GenerationType.TABLE, generator="sequence")
@SequenceGenerator(name="sequence",sequenceName="SQ_TABLE_X", allocationSize=1)
private Long id;

But SELECT SQ_TABLE_X.NEXTVAL FROM DUAL query is made for each persisting
operation and such operation is very slow (the operation insert
about 8000 record in 6/7 minutes). Is there a more quick method to do this?

Thanks


Previous Topic:EclipseLink Bug in DatabaseQuery.checkPrepare
Next Topic:Problem with criteria
Goto Forum:
  


Current Time: Mon Dec 22 04:24:57 GMT 2014

Powered by FUDForum. Page generated in 0.01847 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software