• 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 23:00:35 -0800


On Dec 18, 2008, at 10:19 PM, Guido Neitzer wrote:

On 18.12.2008, at 21:26, Chuck Hill wrote:

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. ;-)

I'm not sure on OR vs. IN, but FrontBase up to the current version cannot use an index on something like:

I was going to say it was you that identified that problem so maybe I am getting confused with something else.



select foo from bar where a = 1 or b = 1;

It can use an index on:

select foo from bar where a = 1 or a = 2;

So, the query in the example SHOULD be okay. But it is obviously not.

Yeah, really not OK.

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
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>)
 >Re: optimization/indexing (From: Chuck Hill <email@hidden>)
 >Re: optimization/indexing (From: Guido Neitzer <email@hidden>)

  • Prev by Date: Re: optimization/indexing
  • Next by Date: Obtaining newly generated primary keys during save
  • Previous by thread: Re: optimization/indexing
  • Next by thread: Re: optimization/indexing
  • Index(es):
    • Date
    • Thread