• 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
EOF Database Connection SQL Processing
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

  • Follow-Ups:
    • Re: EOF Database Connection SQL Processing
      • From: Anjo Krank <email@hidden>
  • Prev by Date: Re: Getting EOF to use multiple DBConnections?
  • Next by Date: Re: EOF Database Connection SQL Processing
  • Previous by thread: Re: Tomcat build & deployment idiot's guide needed
  • Next by thread: Re: EOF Database Connection SQL Processing
  • Index(es):
    • Date
    • Thread