[Dbix-class] use array and composite type to prefetch in Pg

Sam Wong sam at hellosam.net
Sun Mar 15 01:35:20 GMT 2009


SGkgdGhlcmUsCgpJIGFtIG5ldyB0byBPUk0gYW5kIHRvIERCSXg6OkNsYXNzLQoKSW4gUG9zdGdy
ZVNRTCBmZXRjaGluZyBvZiBjb21wb3NpdGUgdHlwZXMgYW5kIGFycmF5IGlzIHN1cHBvcnRlZCwg
YXMgZG9jdW1lbnRlZCBpbgpodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvOC4zL2ludGVy
YWN0aXZlL3Jvd3R5cGVzLmh0bWwKaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzLzguMy9p
bnRlcmFjdGl2ZS9hcnJheXMuaHRtbAoKcHJlZmV0Y2ggcXVlcnkgY2FuIGJlIGNvbnN0cnVjdGVk
IGxpa2UgdGhpcy4uLgoKU0VMRUNUIHBhcmVudHMuKiwgCiAgICBhcnJheShTRUxFQ1QgY2hpbGRz
MS4qIFdIRVJFIGNoaWxkczEucGFyZW50X2lkID0gcGFyZW50cy5pZCk6OmNoaWxkczEsCiAgICBh
cnJheShTRUxFQ1QgY2hpbGRzMi4qIFdIRVJFIGNoaWxkczIucGFyZW50X2lkID0gcGFyZW50cy5p
ZCk6OmNoaWxkczIsCiAgICAuLi4KCndoaWNoIHdpbGwgcmV0dXJucyBzb21ldGhpbmcgbGlrZSB0
aGlzLi4uCmlkIHwgY2hpbGRzMSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
IHwgY2hpbGQyCjEgIHwgKHtjaGlsZF9pZDogeH0sIHtjaGlsZF9pZDogeX0sIHtjaGlsZF9pZDog
en0pIHwgLi4uCjIgIHwgKHtjaGlsZF9pZDogcX0sIHtjaGlsZF9pZDogc30pICAgICAgICAgICAg
ICAgIHwgLi4uCjMgIHwgKCkKNCAgfCAoe2NoaWxkX2lkOiAxfSwge2NoaWxkX2lkOiAyfSkKClRo
aXMgd2lsbCByZXR1cm4gb25seSBPTkUgcm93IGZvciBFQUNIIHBhcmVudHMgcm93LCBubyBtYXR0
ZXIgaG93IG1hbnkKY2hpbGRyZW4ncyB3ZXJlIG91dCB0aGVyZS4KSWYgdGhlIHBhcmVudCBoYXMg
bXVsdGlwbGUgY2hpbGQgcmVsYXRpb25zLCBwcmVmZXRjaGluZyBtdWx0aXBsZSBjaGlsZApyZWxh
dGlvbnMgd2lsbCBhbHNvIHJldHVybiBvbmx5IE9ORSByb3cgcGVyIHBhcmVudCwgd2hpY2ggaXMg
YSBodWdlCnBlcmZvcm1hbmNlIGJlbmVmaXRzLgoKSW4gREJEOjpQZywgQXJyYXkgd2lsbCBiZSAi
aW5mbGF0ZWQiIGludG8gYXJyYXkgcmVmIGF1dG9tYXRpY2FsbHksCmNvbXBvc2l0ZSB0eXBlIHdh
cyBub3QgaW5mbGF0ZWQgdG8gaGFzaCB5ZXQgYnkgREJEOjpQZy4KCkRvZXMgYW55b25lIHRoaW5r
IG9mIHRoaXM/IEFueSBjaGFuY2UgdGhhdCB0aGlzIGNvdWxkIGJlIGltcGxlbWVudGVkIGVhc2ls
eT8KClRoYW5rcywKU2FtCgoKLS0tLS0tLS0tLS0tLS0gbmV4dCBwYXJ0IC0tLS0tLS0tLS0tLS0t
CkFuIEhUTUwgYXR0YWNobWVudCB3YXMgc2NydWJiZWQuLi4KVVJMOiBodHRwOi8vbGlzdHMuc2Nz
eXMuY28udWsvcGlwZXJtYWlsL2RiaXgtY2xhc3MvYXR0YWNobWVudHMvMjAwOTAzMTUvZWRkNzJk
YWYvYXR0YWNobWVudC5odG0K


More information about the DBIx-Class mailing list