[Dbix-class] Weird RelationShip => SQL behavior and Performance Issue

Benoit Plessis benoit at plessis.info
Thu May 31 09:20:02 GMT 2007 

CmhpIGV2ZXJ5b25lLAoKSSdtIGtuZXcgdG8gREJJeDo6Q2xhc3MgKGRpc2NvdmVyZWQgd2l0aCB0
aGUgQ2F0YWx5c3QgZnJhbWV3b3JrKSBidXQKaSB0aGluayBpdCdzIHRlcnJpYmxlICEKCkFueXdh
eSBpIGVuY291bnRlcmVkIHR3byBnb3RjaGFzIHdoaWxlIHVzaW5nIHRoZSB0aGluZyBhbmQgaGVy
ZSB0aGV5IGFyZToKCiAxLyBSZWxhdGlvbnNoaXBzLgoKTGV0J3Mgc2F5IHdlIGhhdmUgMyB0YWJs
ZXMgYW5kIHR3byByZWxhdGlvbjoKICAgIHRhYmxlMS5yZWwxIGlzIGEgKm1pZ2h0X2hhdmUqIG9u
IHRhYmxlMgogICAgdGFibGUyLnJlbDIgaXMgYSAqYmVsb25nc190byogb24gdGFibGUzCgp3aGVu
IGRvaW5nIHNvbWV0aW5nIGxpa2UgdGhhdDoKICAgICRzY2hlbWEtPnJlc3VsdHNldCgnVGFibGUx
JykgLT4gc2VhcmNoICh1bmRlZiwgeyBwcmVmZXRjaCA9PiB7IAondGFibGUyJyA9PiAndGFibGUz
JyB9IH0pOwp0aGUgZ2VuZXJhdGVkIFNRTCBjb2RlIHdpbGwgYmUgc29tZXRoaW5nIGxpa2UgdGhh
dDoKCiAgICAvRlJPTSB0YWJsZTEgTEVGVCBKT0lOIHRhYmxlMiBPTiAodGFibGUxLmYxID0gdGFi
bGUyLmYxKSBKT0lOIHRhYmxlMyAKT04gKHRhYmxlMi5mMiA9IHRhYmxlMy5mMikKCi9UaGUgcHJv
YmxlbSAoYXQgbGVhc3Qgd2l0aCBNeVNRTCA1KSBpcyB0aGUgZm9sbG93aW5nOiBJZiB0aGV5IGFy
ZSAKZW50cmllcyBpbiB0YWJsZTEgd2l0aCBubyBjb3JyZXNwb25kaW5nCmVudHJpZXMgaW4gdGFi
bGUyICh3aXRjaCBpcyB0aGUgcHVycG9zZSBvZiAqbWlnaHRfaGF2ZSogaWl1YykgdGhlIHNlY29u
ZCAKSk9JTiBvbiB0YWJsZTMgd2lsbCByZW1vdmUgdGhvc2VzCmVudHJpZXMgZnJvbSB0aGUgcmVz
dWx0aW5nIHNldC4KCkVnOgogICAgICAgU0VMRUNUIENPVU5UKCopIEZST00gdGFibGUxIExFRlQg
Sk9JTiB0YWJsZTIgPT4gMzAwMCBlbnRyaWVzCiAgICAgICBTRUxFQ1QgQ09VTlQoKikgRlJPTSB0
YWJsZTIgSk9JTiB0YWJsZTMgICAgICAgICAgICA9PiAzMDAgZW50cmllcwogICAgICAgdGhlbiBT
RUxFQ1QgQ09VTlQoKikgRlJPTSB0YWJsZTEgTEVGVCBKT0lOIHRhYmxlMiBKT0lOIHRhYmxlMyAK
d2lsbCBnaXZlIDMwMCByZXBsaWVzCgoKIDIvIFBlcmZvcm1hbmNlIHdlaXJkbmVzcwoKV2hlbiBp
IHVuZGVyc3Rvb2QgdGhlIHByZXZpb3VzIGZhY3QgaSBjdXRlZCBteSBiaWcgc2VhcmNoIHdpdGgg
cHJlZmV0Y2ggCm9uIDEwIHRhYmxlcyBhcyBmYXIgYXMgaSBjYW4gcHJlZmV0Y2ggCndpdGhvdXQg
J2xvc2luZycgZGF0YXMuIFJlc3VsdGluZyBpbiA1LzYgbW9yZSBTUUwgcXVlcmllcyBmb3IgZWFj
aCBsb29wLgogICAgPT4gdGhpcyB0b29rIDFtaW40MHMgdG8gcHJvY2VzcyB0aGUgd2hvbGUgZGF0
YXNldC4KCm15ICRycyA9ICRlcnAtPnJlc3VsdHNldCgnVGFibGUxJyktPnNlYXJjaCh1bmRlZiwK
ICAgICAgICAgICAgICAgICAgICAgICAgeyBwcmVmZXRjaCA9PiBbJ3JlbDEnLCB7IHJlbDIgPT4g
WyAncmVsMycsIAoncmVsNCcsICdyZWw1JywgJ3JlbDYnLCBdLCB9LCBdLCB9KTsKCndoaWxlICht
eSAkZSA9ICRycyAtPiBuZXh0KSB7CgogICAuLi4uOwoKICAgZm9yZWFjaCBteSAkcyAoJGUtPnJl
bDItPnJlbDYoKSkgewogICAgICAgICAkZGF0YXMgPSAkcy0+cmVsNy0+bm9tKCk7CiAgICAgICAK
ICAgICBpZiAobXkgJGIgPSAkcy0+cmVsOCgpKSB7CiAgICAgICAgICAgICAgJGRhdGFzICA9ICgg
JGItPnJlbDktPm5vbSgpICwgJGItPnJlbDEwLT5ub20oKSwgIAokYi0+cmVsMTEtPm5vbSgpICk7
CiAgICAgICAgICAgICB9CiAgICAgfQogIH0KCn0KCgpTbyBpIHRyaWVkIHRvIG9wdGltaXplIHRo
aXMgYnkgY3JlYXRpbmcgYW5vdGhlciBzZWFyY2grcHJlZmV0Y2ggCnJlc3VsdHNldCBvbiB0aGUg
bGFzdCA1IHRhYmxlcyB3aGljaCBpcyBidWlsZApvbmNlIHBlciBsb29wIHVzaW5nIHJlc3VsdCBm
b3IgdGhlIGZpcnN0IHNldC4gVGhlcmUgaXMgdGhlIGZ1bm55IHRoaW5nLCAKaXQgaXMgc2xvd2Vy
IHRoYW4gdGhlIGZpcnN0IGNhc2UgYnkgNzAgc2VjICgybWluNTBzKS4KCm15ICRycyA9ICRlcnAt
PnJlc3VsdHNldCgnVGFibGUxJyktPnNlYXJjaCh1bmRlZiwKICAgICAgICAgICAgICAgICAgICAg
ICAgeyBwcmVmZXRjaCA9PiBbJ3JlbDEnLCB7IHJlbDIgPT4gWyAncmVsMycsIAoncmVsNCcsICdy
ZWw1JywgJ3JlbDYnLCBdLCB9LCBdLCB9KTsKCndoaWxlIChteSAkZSA9ICRycyAtPiBuZXh0KSB7
CgogICAuLi4uOwoKICAgIG15ICRyczIgPSAkZXJwLT5yZXN1bHRzZXQoJ1RhYmxlNycpLT5zZWFy
Y2goeyAibWUubnVtIiA9PiAKJGUtPnJlbDItPm51bV90YWJsZTcoKSB9LAogICAgICAgICAgICAg
ICAgICAgICAgICAgIHsgcHJlZmV0Y2ggPT4gWydyZWw3JywgeyByZWw4ID0+IFsgJ3JlbDknLCAK
J3JlbDEwJywgJ3JlbDExJyBdIH0sXX0pOwogIAogICB3aGlsZSAobXkgJGxpY2VuY2UgPSAkcnMg
LT4gbmV4dCgpKSB7CiAgICAgICAgICRkYXRhcyA9ICRzLT5yZWw3LT5ub20oKTsKICAgICAgIAog
ICAgIGlmIChteSAkYiA9ICRzLT5yZWw4KCkpIHsKICAgICAgICAgICAgICAkZGF0YXMgID0gKCAk
Yi0+cmVsOS0+bm9tKCkgLCAkYi0+cmVsMTAtPm5vbSgpLCAgCiRiLT5yZWwxMS0+bm9tKCkgKTsK
ICAgICAgICAgICAgIH0KICAgICB9CiAgfQoKfQoKSSdtIHVzaW5nIHBlcmwgYW5kIERCSXg6OkNs
YXNzIGFzIG9mIGRlYmlhbi9ldGNoIHJlbGVhc2UgKDUuOC44LTcgYW5kIAowLjA3MDAzLTEpCklm
IHUgbmVlZCBtb2RlIGluZm9ybWF0aW9ucyBmZWVsIGZyZWUgdG8gYXNrLgoKUmVnYXJkcywKYmVu
b2l0CgotLS0tLS0tLS0tLS0tLSBuZXh0IHBhcnQgLS0tLS0tLS0tLS0tLS0KQW4gSFRNTCBhdHRh
Y2htZW50IHdhcyBzY3J1YmJlZC4uLgpVUkw6IGh0dHA6Ly9saXN0cy5zY3N5cy5jby51ay9waXBl
cm1haWwvZGJpeC1jbGFzcy9hdHRhY2htZW50cy8yMDA3MDUzMS84NTI2MDlmNC9hdHRhY2htZW50
Lmh0bQo=

More information about the Dbix-class mailing list