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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
