• 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
Re: optimization/indexing
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: optimization/indexing


  • Subject: Re: optimization/indexing
  • From: Chuck Hill <email@hidden>
  • Date: Thu, 18 Dec 2008 20:26:28 -0800


On Dec 18, 2008, at 8:22 PM, Mike Schrag wrote:

Does WinAnalysis.comboTeamID have an index? I'd guess that it does and that the index is corrupt. Or that is one VERY large table and there is no index. If you can get FrontBase to use an IN instead of ORs that will also make it faster, but you have some kind of hunka burning serious SQL problem happening there.
I seem to recall that FB optimizes these or's into an in query if you look at the execution plan, so I believe you only really save on parse time for that. Wonder does have an ERXInOrQualifier or something like that that turns ors into in-sets given a set of criteria. This used to be the default, but we took it back out after a couple people had problems (I think maybe 5.4-related, but it's been a while). I actually prefer using it, though, as it makes much more sane looking sql.


FB might have fixed that. I am pretty sure that someone was complaining about the OR vs IN difference being quite significant. That might have been FB 3. You know us old folks, we all live in the past. ;-)


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 (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Follow-Ups:
    • Re: optimization/indexing
      • From: Guido Neitzer <email@hidden>
References: 
 >Re: optimization/indexing (From: Jeff Schmitz <email@hidden>)
 >Re: optimization/indexing (From: Chuck Hill <email@hidden>)
 >Re: optimization/indexing (From: Jeff Schmitz <email@hidden>)
 >Re: optimization/indexing (From: Clark Mueller <email@hidden>)
 >Re: optimization/indexing (From: Jeff Schmitz <email@hidden>)
 >Re: optimization/indexing (From: Chuck Hill <email@hidden>)
 >Re: optimization/indexing (From: Mike Schrag <email@hidden>)

  • Prev by Date: Re: optimization/indexing
  • Next by Date: Re: optimization/indexing
  • Previous by thread: Re: optimization/indexing
  • Next by thread: Re: optimization/indexing
  • Index(es):
    • Date
    • Thread