Stuart McLachlan
stuart at lexacorp.com.pg
Thu Sep 15 07:23:51 CDT 2011
If it is stored in memory, how can multi-user/ server based BEs work? How can my workstation read/write locks in the server's memory or the memory on another workstation and/or how can they read my memory? It must be physically written somewhere accessible to all users such as the lock file. -- Stuart On 15 Sep 2011 at 7:47, Jim Dettman wrote: > John, > > A lock is never written to disk. It's completely stored in memory > (unless > of course the OS starts paging to disk because it runs out of memory). > > <<How do I speed that up.>> > > Faster processor and/or memory. > > Jim. > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: Thursday, September 15, 2011 07:35 AM To: Access Developers > discussion and problem solving Subject: Re: [AccessD] How does Access > locking work > > So what is a lock? Something written to disk I assume? Where? > Completely stored in memory? How do I speed that up. > > John W. Colby > www.ColbyConsulting.com > > On 9/15/2011 1:51 AM, Drew Wutka wrote: > > I think I have the old Jet white paper somewhere. But basically Jet > > would 'lock' the .ldb file where it needed to lock the .mdb. So the > > .mdb would never be locked (allowing for multiple edits), and the > > lock on the .mdb would be actually on the .ldb file. > > > > So say the .mdb was 100 megs. And it needed to lock the 50th > > megabyte, the .ldb file was always small (I think it was 64 bits per > > user, up to 255 users), so it would never reach the 50 meg size, but > > the 'lock' would be placed on the 'virtual' 50 meg point of the > > .ldb. > > > > Make sense? > > > > Drew > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >