Yes I know it will scan all the rows, but we need this for those small table that we expect no frequent insert operation on them
Wes Wannemacher wrote: > > That is generally a bad idea. Select max(row) will generally initiate > a full index scan or, even worse, a full table scan. > > -Wes > > On 5/17/09, is_maximum <[email protected]> wrote: >> >> Hello >> >> Can we tell the OpenJPA to automaticall select maximum id from the table >> to >> set the next id rather than using the OPENJPA_SEQUENCE_TABLE or any other >> database object? >> >> thanks >> -- >> View this message in context: >> http://n2.nabble.com/id-and-%40GeneratedValue-tp2916124p2916124.html >> Sent from the OpenJPA Users mailing list archive at Nabble.com. >> >> > > > -- > Wes Wannemacher > Author - Struts 2 In Practice > Includes coverage of Struts 2.1, Spring, JPA, JQuery, Sitemesh and more > http://www.manning.com/wannemacher > > -- View this message in context: http://n2.nabble.com/id-and-%40GeneratedValue-tp2916124p2921077.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
