• 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: EOOrQualifier
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: EOOrQualifier


  • Subject: Re: EOOrQualifier
  • From: Eric Wagner <email@hidden>
  • Date: Fri, 21 Sep 2007 22:02:22 -1000

I was hoping to avoid that, the queries are a little complex and I'm by no means an SQL expert. Looking at the SQL generated it looks like it tried to optimize it some, the Or'd query is only about 1/3 longer than one of the single ones. Unfortunately the code's at the office so I can't provide much more in details until Monday. I was just hoping someone had run into this before and new of an easy fix. My current plan is to just do the two queries separately and then do an in memory sort. I actually lucked out on discovering this since I had another fetch I was doing that returned much larger data sets and I hadn't noticed it was missing a few objects.


On Sep 21, 2007, at 7:28 PM, Ray Ackland wrote:

Eric,

What result sets do you get if you construct the SQL manually for the different queries?

r

On 22/09/2007, at 15:18, email@hidden wrote:

Is there anything that could cause an EOOrQualifier to behave like this or is it a bug? Object's a, b, and c are all from the same table. The qualifiers A and B do have a contains selector for a many to many. This is with mysql v. 5.0.37.


_______________________________________________ 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: 
 >EOOrQualifier (From: email@hidden)
 >Re: EOOrQualifier (From: Ray Ackland <email@hidden>)

  • Prev by Date: Re: EOOrQualifier
  • Next by Date: Re: EOOrQualifier
  • Previous by thread: Re: EOOrQualifier
  • Next by thread: Re: EOOrQualifier
  • Index(es):
    • Date
    • Thread