请问，mysql中是否有sql server查询语句中with(nolock)的选项

Article View: cn.bbs.comp.database

Article #1672

Back to cn.bbs.comp.database Previous Next

#1672

From: stingzou
Date: Wed, 01 Mar 2006 10:17

3 lines
1347 bytes

以前用mssql时，有with(nolock)可以保证在高并发情况下依然能快速读取数据，但现在mysql中我没有找到相应的选项，请问有人能回答这个问题吗？

Technical Details

Message-ID: <1141208272.994049.61880@t39g2000cwt.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!t39g2000cwt.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 101948,e843dfd7d40f5c7f,start
X-Google-Attributes: gid101948,public
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!t39g2000cwt.googlegroups.com!not-for-mail
From: "stingzou" <stingzou@gmail.com>
Newsgroups: cn.bbs.comp.database
Subject: 请问，mysql中是否有sql server查询语句中with(nolock)的选项
Date: 1 Mar 2006 02:17:53 -0800
Organization: http://groups.google.com
Lines: 4
Message-ID: <1141208272.994049.61880@t39g2000cwt.googlegroups.com>
NNTP-Posting-Host: 222.66.40.68
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: base64
X-Trace: posting.google.com 1141208278 29842 127.0.0.1 (1 Mar 2006 10:17:58 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 1 Mar 2006 10:17:58 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.2; zh-CN; rv:1.8.0.1) Gecko/20060111 Firefox/1.5.0.1,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: t39g2000cwt.googlegroups.com; posting-host=222.66.40.68;
   posting-account=f7PZew0AAABDk6JQKFujRZxGl2rKi60U