Quote:
Will it use 'Table' Strategy in both data bases or 'Sequence' Strategy in Oracle and 'Identity' Strategy in MS SQL?
In MS-SQL I'm sure 'Auto' is using 'Identity' Strategy
whilst under Oracle I believe it uses a sequence as 'Identity' Strategy is not supported by Oracle.
Quote:
Is that advisable to use 'Auto' Strategy in large scale applications?
It depends to which concrete-strategy 'Auto' falls back on your concrete databases.
'Identity' Strategy is in my opinion not so good for applications which do massive inserts,
as with this strategy, every persist action requires an extra database hit to obtain the primary key
(in most other strategies the primary key is most times calculated without database hit).
Login
FAQ
Search
