• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: database slowness weirdness
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: database slowness weirdness


  • Subject: Re: database slowness weirdness
  • From: Chuck Hill <email@hidden>
  • Date: Mon, 26 Apr 2004 14:26:08 -0700

Sounds like the db / your connection is doing table level locking instead of row level locking. Or something is reading or updating so much of that table that the entire thing is being locked. Is anything else accessing the table?


On Apr 26, 2004, at 1:35 PM, Jonathan Rochkind wrote:

I guess there's something bad going on with db-level locking. The db is locking out that update SQL because someone else is doing something that requires a db-level lock. All underneath the hood---none of my code explicitly aquires a lock, but maybe a lock is implied by an 'update' whether you like it or not. I don't really know what I'm talking about, I'm just guessing here, in case anyone has anything useful to suggest.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.


  • Follow-Ups:
    • Re: database slowness weirdness
      • From: Jonathan Rochkind <email@hidden>
References: 
 >database slowness weirdness (From: Jonathan Rochkind <email@hidden>)

  • Prev by Date: Re: WORepetition error
  • Next by Date: Re: database slowness weirdness
  • Previous by thread: database slowness weirdness
  • Next by thread: Re: database slowness weirdness
  • Index(es):
    • Date
    • Thread