On Aug 7, 2008, at 10:10 PM, Shelley Eitzen wrote:
Hi All,
We are looking at reducing the number of queries made to our
Openbase database. When you look at the Openbase sql log file it
appears to repeat a number of queries.
Openbase are suggesting we set an objects time to live to be 10
seconds to eliminate or reduce these extra queries. Does anyone
know what this means in terms of WebObjects?
Not much, I'd guess. The default is 60 minutes...
A long time ago we unticked the caching checkbox in Java monitor as
information was not being shared between instances, so I don't want
to turn this back on.
I think that is only component template caching.
The only thing I can find is
http://wiki.objectstyle.org/confluence/display/WO/EOF-Using+EOF-Caching+and+Freshness
but in short I don't feel confident that this will actually solve
our problem.
One important thing to note is we use the
session.defaultEditingContext virtually everywhere (except reports)
Can anyone suggest a silver bullet?
I suspect this is what you are missing:
http://wiki.objectstyle.org/confluence/display/WO/EOF-Modeling-EOModeler#EOF-Modeling-EOModeler-BatchFaulting
Chuck
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
