[Dbix-class] Why is prefetch so slow?

Hartmaier Alexander Alexander.Hartmaier at t-systems.at
Fri Oct 12 12:07:01 GMT 2007


WmVybyB0aW1lIHNxbCEKU291bmRzIGxpa2UgYSBXaG9yYWNsZSBmZWF0dXJlIGZvciB2ZXJzaW9u
IDEyIQpPciB0aGUgbmV4dCBiaWcgdGhpbmcgZm9yIERhbWlhbiBDb253YXkgYWZ0ZXIgaGlzIHRo
aXMgeWVhcidzIFlBUEM6OkVVIHRhbGsuLi4KCi1BbGV4CgoKLS0tLS1PcmlnaW5hbCBNZXNzYWdl
LS0tLS0KRnJvbTogSm9uIFNjaHV0eiBbbWFpbHRvOmpvbitkYml4QHlvdXJhbWlnby5jb21dClNl
bnQ6IEZyaWRheSwgT2N0b2JlciAxMiwgMjAwNyAxMDo0OSBBTQpUbzogREJJeDo6Q2xhc3MgdXNl
ciBhbmQgZGV2ZWxvcGVyIGxpc3QKU3ViamVjdDogUmU6IFtEYml4LWNsYXNzXSBXaHkgaXMgcHJl
ZmV0Y2ggc28gc2xvdz8KCk9uIEZyaSwgMjAwNy0xMC0xMiBhdCAwODo1MSArMDEwMCwgV2lsbCBI
YXdlcyB3cm90ZToKPiBPbiAxMi8xMC8yMDA3LCBKb24gU2NodXR6IDxqb24rZGJpeEB5b3VyYW1p
Z28uY29tPiB3cm90ZToKPiAgICAgICAgIEluIG15IGNvZGUgSSBoYXZlIGEgREJJeDo6Q2xhc3Mg
cXVlcnkgd2l0aCBwcmVmZXRjaCB0aGF0IGlzCj4gICAgICAgICB0YWtpbmcgYWJvdXQKPiAgICAg
ICAgIDEuMiBzZWNvbmRzIHRvIGV4ZWN1dGUuICBJZiBJIHJlbW92ZSB0aGUgcHJlZmV0Y2gsIGl0
IHRha2VzCj4gICAgICAgICAwLjIgc2Vjb25kcy4KPiAgICAgICAgIFRoZSBhY3R1YWwgU1FMIHF1
ZXJ5IHRha2VzIDAuMDAgc2Vjb25kcyB3aXRoIG9yIHdpdGhvdXQgdGhlCj4gICAgICAgICBqb2lu
LiAgVGhlCj4gICAgICAgICBudW1iZXIgb2YgcmVjb3JkcyBpcyB0aGUgc2FtZSB3aXRoIGFuZCB3
aXRob3V0IHRoZQo+ICAgICAgICAgcHJlZmV0Y2gvam9pbi4KClsgc25pcCBdCgo+Cj4gSGF2ZSB5
b3UgdmVyaWZpZWQgd2hhdCBTUUwgc3RhdGVtZW50IGlzIGJlaW5nIGdlbmVyYXRlZCBieSBzZXR0
aW5nCj4gREJJQ19UUkFDRT0xIHByaW9yIHRvIHJ1bm5pbmcgeW91ciBzY3JpcHQ/IEl0J3Mgbm90
IGNsZWFyIGZyb20geW91cgo+IHF1ZXN0aW9uLiBJZiBub3QgdGhpcyBtaWdodCBnaXZlIG1vcmUg
aW5zaWdodCBpbnRvIHRoZSBwcm9ibGVtLgo+Cj4KClllcywgdGhlIGFjdHVhbCBTUUwgcXVlcnkg
dGFrZXMgMC4wMCBzZWNvbmRzIHdpdGggb3Igd2l0aG91dCB0aGUgam9pbiBpZgpJIGN1dCBhbmQg
cGFzdGUgdGhlIHRyYWNlIG91dHB1dCBpbnRvIHRoZSBteXNxbCBjbGllbnQuCgoKCgoKX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KTGlzdDogaHR0cDovL2xp
c3RzLnNjc3lzLmNvLnVrL2NnaS1iaW4vbWFpbG1hbi9saXN0aW5mby9kYml4LWNsYXNzCklSQzog
aXJjLnBlcmwub3JnI2RiaXgtY2xhc3MKU1ZOOiBodHRwOi8vZGV2LmNhdGFseXN0LnBlcmwub3Jn
L3JlcG9zL2Jhc3QvREJJeC1DbGFzcy8KU2VhcmNoYWJsZSBBcmNoaXZlOiBodHRwOi8vd3d3Lmdy
b2tiYXNlLmNvbS9ncm91cC9kYml4LWNsYXNzQGxpc3RzLnJhd21vZGUub3JnCgotLS0tLS0tLS0t
LS0tLSBuZXh0IHBhcnQgLS0tLS0tLS0tLS0tLS0KQSBub24tdGV4dCBhdHRhY2htZW50IHdhcyBz
Y3J1YmJlZC4uLgpOYW1lOiBzbWltZS5wN3MKVHlwZTogYXBwbGljYXRpb24veC1wa2NzNy1zaWdu
YXR1cmUKU2l6ZTogNTYxMSBieXRlcwpEZXNjOiBub3QgYXZhaWxhYmxlClVybCA6IGh0dHA6Ly9s
aXN0cy5zY3N5cy5jby51ay9waXBlcm1haWwvZGJpeC1jbGFzcy9hdHRhY2htZW50cy8yMDA3MTAx
Mi84YmE1NDI3MC9zbWltZS0wMDAxLmJpbgo=


More information about the DBIx-Class mailing list