Hi Eric,
Ferrer, Eric wrote:
Is it possible to hint to OJB on persisted calls to use the WITH (NO
LOCK) attributes on tables?
The "WITH (NOLOCK)" clause is a proprietary sql extension for mssql, so
same problem as with "native limit" support. If using "WITH (NOLOCK)"
dirty reads can occur -
Is it possible to hint to OJB on persisted calls to use the WITH (NO
LOCK) attributes on tables?
When ever we are in a multiple transaction and selecting data from large
tables we sometimes slow things down and for performance reasons
sometimes have to create views.
Thanks
-Eric