Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Latest News: Magecart Attacks Grow Rampant in September

Featured Deal: Get 92% off The Complete Cisco Network Certification Training Bundle

Upper End For MaxLocksPerFile Value

Started by TheGreyGuy , Jul 20 2010 10:59 AM

Please log in to reply

2 replies to this topic

#1 TheGreyGuy

Members
28 posts
OFFLINE

Gender:Male
Location:Tacoma, WA
Local time:08:47 PM

Posted 20 July 2010 - 10:59 AM

While working on an MS Access problem someone recommended I increase the MaxLocksPerFile value from the 9500 default to 200,000 shown in the example from MS Support. It didn't solve my problem but my users other queries ran faster. This is generally considered a good thing.

So here is my question... what is the upper limit for the MaxLocksPerFile value? Reasoning that if 200K is good 500K must be better right? :thumbsup: