A great feature to help you see the WHERE part of suboptimal indices is
the built-in EOAdaptorContextDelegate in Project Wonder. Simply include
ERExtensions framework and put something like this in your Properties
file.....
log4j.logger.er.extensions.ERXAdaptorChannelDelegate.sqlLogging=TRUE
########################################################################
#
# ERXAdaptorChannelDelegate
########################################################################
#
## Enable delegate to emit SQL debugging info. The Logger used is
## log4j.category.er.extensions.ERXAdaptorChannelDelegate.sqlLogging
er.extensions.ERXAdaptorChannelDelegate.enabled=true
## How long a statement must run to cause a log message. Messages with
longer than
## error also emit a stack-trace
er.extensions.ERXAdaptorChannelDelegate.trace.milliSeconds.debug=10
er.extensions.ERXAdaptorChannelDelegate.trace.milliSeconds.info=100
er.extensions.ERXAdaptorChannelDelegate.trace.milliSeconds.warn=1000
er.extensions.ERXAdaptorChannelDelegate.trace.milliSeconds.error=5000
## MaxLength of the message
er.extensions.ERXAdaptorChannelDelegate.trace.maxLength = 3000
## What entities to watch
er.extensions.ERXAdaptorChannelDelegate.trace.entityMatchPattern = .*
_________________________________________________
One thing about EOModeler is that every attribute has optimistic
locking turned on by default. This creates big WHERE clauses which can
slow you down on non-indexed fields. My feeling is that optimistic
locking should be turned on on essential fields only and then index
those since WO _will_ use then in sql WHERE clauses.
Regards, Kieran
On Feb 9, 2006, at 9:32 PM, Chuck Hill wrote:
I have no idea whether my suggestions will accelerate your app, but
they'd be worth a quick try. Also, you should ensure that the DB
columns involved are indexed.
Yep. That is probably the #1 cause of slow WO apps.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
