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

@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?


Previous Topic:Problem with criteria
Next Topic:MongoDB queries throwing NPE
Goto Forum:

Current Time: Tue Jan 23 17:43:09 GMT 2018

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

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