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 12:12
F C is currently offline F C
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: Fri Apr 18 04:06:49 EDT 2014

Powered by FUDForum. Page generated in 0.01978 seconds