database slowness weirdness
database slowness weirdness
- Subject: database slowness weirdness
- From: Jonathan Rochkind <email@hidden>
- Date: Mon, 26 Apr 2004 15:35:46 -0500
This isn't really a WO question, but maybe someone has some ideas.
I use MS SQL Server 7 as my database. When a user logs in, I save
in the database, in their User record, a 'lastLoginTimestamp' value
is updated. Make the change, saveChanges() in an EC, which obviously
triggers an SQL 'update' statement.
In some cases, that SQL update takes a long long time to execute.
Like tens of seconds, even over a minute.
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.
--Jonathan
_______________________________________________
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.