• 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
Question about search performance
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Question about search performance


  • Subject: Question about search performance
  • From: Joshua Dubey <email@hidden>
  • Date: Tue, 16 Sep 2008 10:35:42 -0700

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@hidden%') 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@hidden') 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@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

  • Follow-Ups:
    • Re: Question about search performance
      • From: Petite Abeille <email@hidden>
    • Re: Question about search performance
      • From: Chuck Hill <email@hidden>
  • Prev by Date: Re: WebObjects 5.4.3 is out
  • Next by Date: Re: Question about search performance
  • Previous by thread: Re: WebObjects 5.4.3 is out
  • Next by thread: Re: Question about search performance
  • Index(es):
    • Date
    • Thread