| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Is it possible to use nolock type of hint in query
SQL Server's default behavior is autocommit of each DML statement. Why? To keep transactions short, because that's the only way to get reasonable performance. The constant drumbeat of "keep transactions short" is a classic tail-wagging-the-dog position.
Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com
-----Original Message-----
From: Peter McLarty [mailto:Peter_McLarty_at_technologyonecorp.com]
Sent: Tuesday, August 15, 2006 3:00 AM
To: jkstill_at_gmail.com; norman.dunbar_at_environment-agency.gov.uk
Cc: paul.baumgartel_at_credit-suisse.com; oracle-l_at_freelists.org; ineyman_at_perceptron.com
Subject: RE: Is it possible to use nolock type of hint in query
I will buy in with my two cents worth here from what I know of the use of nolock
Firstly it is part of a standard SQL Server approach to solving a performance issue that can arise and to help SQL server to run multiuser, yes that right multiuser
Due to the inadequacies of the sQL Server locking paradigm many applications need to run transactions as read uncommmited. This is due to the way SQL server locks when running a select. This delivers a problem in that if say posting is running then the session of a user running a select on the same tables needs to run select with a nolock or else the select will likely lock the table and cause the posting process to fail
Which now begs the question is SQL Server a real database and how the hell do you effectively scale it because there whole strategy seems to be built on a number of fudges?
My 0.02c
Cheers
Peter McLarty
Technical Consultant
Service Delivery
Address:
67 High Street, Toowong QLD 4066
Phone:
+61733777542
Fax:
+61 7 3377 7301
Mobile:
+61410620391
Email:
Peter_McLarty_at_TechnologyOneCorp.com <mailto:Peter_McLarty_at_TechnologyOneCorp.com>
Web:
www.TechnologyOneCorp.com <http://www.technologyonecorp.com>
EVOLVE 2007 - Connect. Learn. Empower.
Register today for the TechnologyOne Evolve 2007 User Conference
13 - 16 February 2007
Gold Coast Convention & Exhibition Centre, Queensland, Australia
www.TechnologyOneCorp.com/Evolve <http://www.technologyonecorp.com/Evolve>
.
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 15 2006 - 08:27:01 CDT
 |
 |