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:
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. cug _______________________________________________ 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]
