Hi Ken,
Changes have not yet been deployed, so nothing to report yet. I will
provide an update when we go live.
Thanks,
Josh
On Oct 2, 2008, at 11:20 AM, Ken Anderson wrote:
Josh,
Can you please tell us what the outcome was of this?
Ken
On Sep 16, 2008, at 1:35 PM, Joshua Dubey wrote:
Hi,
I am seeing some search performance behavior I don't understand and
am hoping someone can provide some insight.
We have an application that searches a very large table (millions
of rows) for orders. We have options to search with wild cards,
and and do case insensitive searches. Typical generated SQL for
case insensitive wild card search looks like this:
SELECT <bunch of attributes>, from ORDERS T0 WHERE
UPPER(T0.EMAIL_ADDRESS) LIKE UPPER('[EMAIL PROTECTED]') ESCAPE '\;
This query can take up to a minute and a half. It takes the same
amount of time whether the query is run directly against our
database or using our application. This is what I would expect.
A case insensitive non wild card search produces SQL below
SELECT <bunch of attributes>, from ORDERS T0 WHERE
UPPER(T0.EMAIL_ADDRESS) LIKE UPPER('[EMAIL PROTECTED]') ESCAPE '\;
Here is what I don't understand: If I run the above query directly
against our database, it takes about 12 seconds. However, running
it through the app still takes about a minute and a half.
Can anyone explain why this might be from an EOF perspective?
Thanks,
Josh
_______________________________________________
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/kenlists%40anderhome.com
This email sent to [EMAIL PROTECTED]
_______________________________________________
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]
