EOAndQualifier order
EOAndQualifier order
- Subject: EOAndQualifier order
- From: Miguel Arroz <email@hidden>
- Date: Wed, 11 Jul 2007 22:29:47 +0100
Hi!
I'm looking and the generated SQL from an EOAndQualifier, and it
looks like the order of the "anded" stuff is the inverse one I write
on the code. If I write a qualifier like "bananas = %@ and apples = %
@ and oranges = %@", the generated SQL will be the reverse
(t0.oranges = (...) AND t0.apples = (...) AND to.bananas = (...)".
Is this normal? Is the order random? What's happening here? I'm
asking this, because from what I understand form the PostgreSQL docs,
the order of the stuff in ANDs (and ORs) may have cause a really big
difference in performance when indexes (and multi-indexes) are envolved.
Yours
Miguel Arroz
Miguel Arroz
http://www.terminalapp.net
http://www.ipragma.com
_______________________________________________
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