It was my DBA who recommended it, and yes, these tables are extremely large (approx. 17-22 million records). He was telling me that by doing this, you avoid having to create exclusive locks in the master. Now by caching the resultsets, you are talking about doing this through CF right? Or is there some way of doing this through MSSQL that I don't know about?
Thanks again, robert -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of David L. Penton Sent: Tuesday, September 17, 2002 9:09 PM To: [EMAIL PROTECTED] Subject: RE: Using (NOLOCK) in MSSQL2k? It's not really for performance as much as concurrency. If you find you are querying this data quite often (and it is very large, like in the 10s of millions or +), you might look into caching resultsets and querying the cache instead. David L. Penton, Microsoft MVP JCPenney Technical Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Robert Hinojosa How often do you all use (NOLOCK) in your SQL queries when doing a select? How much of a performance gain do you really gain when doing a select statement of large tables? I've been starting to use it more and more, but performance hasn't really increased much, and I'm just wondering what kinds of experiences you all have had. Robert ------------------------------------------------------------------------ - This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
