EOF Database Connection SQL Processing
EOF Database Connection SQL Processing
- Subject: EOF Database Connection SQL Processing
- From: Dov Rosenberg <email@hidden>
- Date: Wed, 27 Jul 2005 08:10:50 -0400
Title: EOF Database Connection SQL Processing
I have been using WO/EOF for several years (since 1997) but have never really appreciated how well EOF handles multiplexing SQL from multiple sessions thru a single database connection. One of our newest customers was doing a some performance testing and we were running into some problems with database locks with multiple users doing the same thing concurrently. We had 10 users clicking the SAVE button at the same time. As we were debugging what was going on – the customer kept asking why there was only a single database connection that was active for all of the users. I had a hard time trying to explain the magic that went on behind the scenes in a manner that would convince them that EOF was not the problem.
They kept on insisting that I needed to use more database connections to prevent the locks from occurring. It turns out that the database installation on their linux server had some problems – not our code.
QUESTION:
Is there a way to get some stats from WO/EOF on how many queries are being handled, average time, etc. in a manner like the WOStats page? I know we can turn on various levels of NSLogging, I want to set up some diagnostic pages to provide admin people a view into what is happening.
Thanks in advance
--
Dov Rosenberg
Conviveon/Inquira
Knowledge Management Experts
http://www.conviveon.com
http://www.inquira.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden