Re: Server side cursors and locking

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



> Does the cache size really affect which records get locked? I messed with
> it
> and it seems to me that it always locks the entire result set.

Are you in a transaction?

Stephen Howe


.



Relevant Pages

  • Re: spinaphore conceptual draft
    ... >>I suspect any attempt to use time stamps in locks is a bad ... >>CPU will always snoop cache accesses for all cache lines ... > The idea behind these locks is for bigger systems for ... and a lock such as this should be able to send several CPUs to ...
    (Linux-Kernel)
  • Re: fcntl(F GETLEASE) semantics??
    ... > can't place a read lease, but can place a write lease! ... that screws with the ability to cache data. ... and nobody else holds locks on the file. ...
    (Linux-Kernel)
  • Re: Performance difference of various synchronization instructions?
    ... location must be brought into cache if it is cacheable. ... if the instruction has a LOCK prefix (or is an XCHG instruction), ... But the 99.9% case is that a LOCK prefix or XCHG instructions locks ... with anything going on on the bus. ...
    (comp.programming.threads)
  • Re: [RFC][PATCH 1/7] Resource counters
    ... If I am not mistaken, you shouldn't loop in normal cases, which means ... If you care about optimization cache lines ... With spin locks you have to be a little more careful to put them ... With atomic ops you get that automatically. ...
    (Linux-Kernel)
  • Re: FUSE merging?
    ... > plays nicely with the page cache. ... on the underlying file server. ... > talking about a virtual filesystem where all calls should be passed ... We have exclusive open semantics but not locks in the Posix ...
    (Linux-Kernel)