Re: Performance of objects

"Walter Dörwald" <[email protected]> Wed, 30 Aug 2017 11:40:34 +0200
Newsgroups gmane.comp.python.db.cx-oracle
Message-ID <[email protected]>
T24gMzAgQXVnIDIwMTcsIGF0IDE6MDksIEFudGhvbnkgVHVpbmluZ2Egd3JvdGU6Cgo+IEhpIFdh
bHRlciwKPgo+IEkganVzdCB0cmllZCB0aGlzIG9uIExpbnV4IHdpdGggMTIuMiBDbGllbnQgYW5k
IERhdGFiYXNlLiBJIGdvdCB0aGVzZQo+IHJlc3VsdHM6Cj4KPiB0YWJsZSAxLjEyMTc1ODY5OTQx
NzExNDMKPiBvYmplY3QgMC44NTkyOTIwMzAzMzQ0NzI3Cj4KPiBXaGVuIEkgY2hhbmdlIHRoZSBu
dW1iZXIgb2YgaXRlcmF0aW9ucyBmcm9tIDEzMDAgdG8gMTIwMCBJIGdldCB0aGlzOgo+Cj4gdGFi
bGUgMC45OTY0NjQ3MjkzMDkwODIKPiBvYmplY3QgMC43NDcxOTQ3NjY5OTgyOTEKPgo+IFNvIGl0
IHNlZW1zIGNvbnNpc3RlbnQuIEFyZSB5b3UgYWJsZSB0byB0cnkgd2l0aCBhIGRpZmZlcmVudAo+
IGRhdGFiYXNlL2NsaWVudCBzY2VuYXJpbyB0byBzZWUgaWYgdGhlIGlzc3VlcyB5b3UgYXJlIHNl
ZWluZyBhcmUgdmVyc2lvbgo+IHNwZWNpZmljPwoKSSByZXRyaWVkIG9uIExpbnV4IHdpdGggdGhl
IHNhbWUgZGF0YWJhc2U6CgpJbiBbMV0g4pa4IGltcG9ydCBjeF9PcmFjbGUKSW4gWzJdIOKWuCBj
eF9PcmFjbGUuY2xpZW50dmVyc2lvbigpCk91dFszXSDilrggKDExLCAyLCAwLCAyLCAwKQpJbiBb
NF0g4pa4IGN4X09yYWNsZS52ZXJzaW9uCk91dFs0XSDilrggJzYuMC4xJwpJbiBbNV0g4pa4IGRi
ID0gY3hfT3JhY2xlLmNvbm5lY3QoInVzZXIvcHdkQGRiIikKSW4gWzZdIOKWuCBkYi52ZXJzaW9u
Ck91dFs2XSDilrggJzExLjIuMC4xLjAnCgpXaXRoIDEyMDAgaXRlcmF0aW9ucyBJIGdldDoKCnRh
YmxlIDAuMzYwNDYwNTE5NzkwNjQ5NApvYmplY3QgMC44OTA1NDc3NTIzODAzNzExCmVxdWFsIFRy
dWUKCldpdGggMTMwMCBpdGVyYXRpb25zIEkgZ2V0OgoKdGFibGUgMC4zODA0NTk1NDcwNDI4NDY3
Cm9iamVjdCA0Mi44OTg5ODgyNDY5MTc3MjUKZXF1YWwgVHJ1ZQoKVGhlIHN0cmFuZ2UgdGhpbmcg
aXMgdGhhdAoKICAgYy5leGVjdXRlKCJzZWxlY3QgdGVzdF9ldmVudHMyIGZyb20gZHVhbCIpCgp0
YWtlcyAwLjIgc2Vjb25kcyBhbmQKCiAgIG9ianMgPSBjLmZldGNob25lKClbMF0uYXNsaXN0KCkK
CnRha2VzIDAuMSBzZWNvbmRzLCBidXQgYWNjZXNzaW5nIHRoZSBhdHRyaWJ1dGVzIHRha2VzIDQy
IHNlY29uZHMuCgpJIGFsc28gdHJpZWQgdGhlIHNjcmlwdCBvbiBMaW51eCBhZ2FpbnN0IGEgMTIu
MS4wLjIuMCBkYXRhYmFzZS4gVGhlIG91dHB1dDoKCnRhYmxlIDAuNTA1ODc4NDQ4NDg2MzI4MQpv
YmplY3Qgc2VsZWN0IDAuMjA1MzAxMjg0NzkwMDM5MDYKb2JqZWN0IGZldGNoIDAuMTAyMTM1NjU4
MjY0MTYwMTYKb2JqZWN0IGNvbnZlcnQgMTEwLjQzOTk1MTQxOTgzMDMyCm9iamVjdCAxMTAuNzQ3
NDcwMzc4ODc1NzMKZXF1YWwgVHJ1ZQoKU28gbWF5YmUgdGhpcyBwcm9ibGVtIGlzIHNwZWNpZmlj
IHRvIHRoZSBjbGllbnQgdmVyc2lvbj8KCk9yIGl0IGhhcHBlbnMgb24gYWxsIHZlcnNpb25zLCBi
dXQgdGhlIHRocmVzaG9sZCBpcyBoaWdoZXI/Cgo+IEFudGhvbnkKPgo+IE9uIFRodSwgQXVnIDI0
LCAyMDE3IGF0IDExOjI4IEFNLCBXYWx0ZXIgRMO2cndhbGQgPHdhbHRlckBsaXZpbmdsb2dpYy5k
ZT4KPiB3cm90ZToKPgo+PiBIZWxsbyBhbGwhCj4+Cj4+IE5vdyB0aGF0IGN4X09yYWNsZSBzdXBw
b3J0cyBjdXN0b20gT3JhY2xlIG9iamVjdCB0eXBlcyBJIHRyaWVkIHRoZW0gYW5kCj4+IGRpc2Nv
dmVyZWQgc3RyYW5nZSBwZXJmb3JtYW5jZSBmbHVjdHVhdGlvbnMuIEkgZGVmaW5lZCB0aGUgZm9s
bG93aW5nIHR5cGVzCj4+IGFuZCBmdW5jdGlvbnMgaW4gdGhlIGRhdGFiYXNlOgo+Pgo+PiAtLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KPj4KPj4gY3JlYXRlIG9y
IHJlcGxhY2UgdHlwZSB1bDRvbmV2ZW50IGFzIG9iamVjdAo+PiAoCj4+ICAgICAgICAgdWVfdHlw
ZSB2YXJjaGFyMigyMCksCj4+ICAgICAgICAgdWVfYmFja3JlZiBpbnRlZ2VyLAo+PiAgICAgICAg
IHVlX2ludDEgaW50ZWdlciwKPj4gICAgICAgICB1ZV9pbnQyIGludGVnZXIsCj4+ICAgICAgICAg
dWVfaW50MyBpbnRlZ2VyLAo+PiAgICAgICAgIHVlX251bWJlciBudW1iZXIsCj4+ICAgICAgICAg
dWVfZGF0ZSBkYXRlLAo+PiAgICAgICAgIHVlX3N0ciB2YXJjaGFyMigzMjAwMCkKPj4gKTsKPj4g
Lwo+Pgo+PiBjcmVhdGUgb3IgcmVwbGFjZSB0eXBlIHVsNG9uZXZlbnRzIGFzIHRhYmxlIG9mIHVs
NG9uZXZlbnQ7Cj4+IC8KPj4KPj4gY3JlYXRlIG9yIHJlcGxhY2UgZnVuY3Rpb24gdGVzdF9ldmVu
dHMyCj4+IHJldHVybiB1bDRvbmV2ZW50cwo+PiBhcwo+PiAgICAgICAgIHZfZXZlbnRzIHVsNG9u
ZXZlbnRzOwo+Pgo+PiAgICAgICAgIHByb2NlZHVyZSBhcHBlbmQoCj4+ICAgICAgICAgICAgICAg
ICBwX3VlX3R5cGUgdmFyY2hhcjIsCj4+ICAgICAgICAgICAgICAgICBwX3VlX2JhY2tyZWYgaW50
ZWdlciA6PSBudWxsLAo+PiAgICAgICAgICAgICAgICAgcF91ZV9pbnQxIGludGVnZXIgOj0gbnVs
bCwKPj4gICAgICAgICAgICAgICAgIHBfdWVfaW50MiBpbnRlZ2VyIDo9IG51bGwsCj4+ICAgICAg
ICAgICAgICAgICBwX3VlX2ludDMgaW50ZWdlciA6PSBudWxsLAo+PiAgICAgICAgICAgICAgICAg
cF91ZV9udW1iZXIgbnVtYmVyIDo9IG51bGwsCj4+ICAgICAgICAgICAgICAgICBwX3VlX2RhdGUg
ZGF0ZSA6PSBudWxsLAo+PiAgICAgICAgICAgICAgICAgcF91ZV9zdHIgdmFyY2hhcjIgOj0gbnVs
bAo+PiAgICAgICAgICkKPj4gICAgICAgICBhcwo+PiAgICAgICAgIGJlZ2luCj4+ICAgICAgICAg
ICAgICAgICB2X2V2ZW50cy5leHRlbmQ7Cj4+ICAgICAgICAgICAgICAgICB2X2V2ZW50cyh2X2V2
ZW50cy5jb3VudCkgOj0gdWw0b25ldmVudChwX3VlX3R5cGUsCj4+IHBfdWVfYmFja3JlZiwgcF91
ZV9pbnQxLCBwX3VlX2ludDIsIHBfdWVfaW50MywgcF91ZV9udW1iZXIsIHBfdWVfZGF0ZSwKPj4g
cF91ZV9zdHIpOwo+PiAgICAgICAgIGVuZDsKPj4gYmVnaW4KPj4gICAgICAgICB2X2V2ZW50cyA6
PSB1bDRvbmV2ZW50cygpOwo+Pgo+PiAgICAgICAgIGFwcGVuZCgnYmVnaW5saXN0Jyk7Cj4+ICAg
ICAgICAgICAgICAgICBmb3IgaSBpbiAxIC4uIDEzMDAgbG9vcAo+PiAgICAgICAgICAgICAgICAg
ICAgICAgICBhcHBlbmQoJ2JlZ2luZGljdCcpOwo+PiAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgIGFwcGVuZCgnc3RyJywgcF91ZV9zdHI9PidmaXJzdG5hbWUnKTsKPj4gICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICBhcHBlbmQoJ3N0cicsIHBfdWVfc3RyPT4nRm9vJyk7Cj4+
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgYXBwZW5kKCdzdHInLCBwX3VlX3N0cj0+
J2xhc3RuYW1lJyk7Cj4+ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgYXBwZW5kKCdz
dHInLCBwX3VlX3N0cj0+J0JhcicpOwo+PiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
IGFwcGVuZCgnc3RyJywgcF91ZV9zdHI9Pidub25lJyk7Cj4+ICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgYXBwZW5kKCdub25lJyk7Cj4+ICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgYXBwZW5kKCdzdHInLCBwX3VlX3N0cj0+J2Jvb2wnKTsKPj4gICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICBhcHBlbmQoJ2Jvb2wnLCBwX3VlX2ludDE9PjEpOwo+PiAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgIGFwcGVuZCgnc3RyJywgcF91ZV9zdHI9PidpbnQnKTsK
Pj4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBhcHBlbmQoJ2ludCcsIHBfdWVfaW50
MT0+NDIpOwo+PiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGFwcGVuZCgnc3RyJywg
cF91ZV9zdHI9PidmbG9hdCcpOwo+PiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGFw
cGVuZCgnbnVtYmVyJywgcF91ZV9udW1iZXI9PjQyLjUpOwo+PiAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgIGFwcGVuZCgnc3RyJywgcF91ZV9zdHI9PidkYXRlJyk7Cj4+ICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgYXBwZW5kKCdkYXRlJywKPj4gcF91ZV9kYXRlPT50b19k
YXRlKCcyOS4wMi4yMDAwJywgJ0RELk1NLllZWVknKSk7Cj4+ICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgYXBwZW5kKCdzdHInLCBwX3VlX3N0cj0+J2NvbG9yJyk7Cj4+ICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgYXBwZW5kKCdjb2xvcicsIHBfdWVfaW50MT0+ODQ1NDUz
MDAwKTsKPj4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBhcHBlbmQoJ3N0cicsIHBf
dWVfc3RyPT4ndGltZWRlbHRhJyk7Cj4+ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
YXBwZW5kKCd0aW1lZGVsdGEnLCBwX3VlX2ludDE9PjAsCj4+IHBfdWVfaW50Mj0+NDIsIHBfdWVf
aW50Mz0+MCk7Cj4+ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgYXBwZW5kKCdzdHIn
LCBwX3VlX3N0cj0+J21vbnRoZGVsdGEnKTsKPj4gICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICBhcHBlbmQoJ21vbnRoZGVsdGEnLCAxNyk7Cj4+ICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgYXBwZW5kKCdzdHInLCBwX3VlX3N0cj0+J3NsaWNlJyk7Cj4+ICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgYXBwZW5kKCdzbGljZScsIHBfdWVfaW50MT0+MTcsCj4+IHBf
dWVfaW50Mj0+MjMpOwo+PiAgICAgICAgICAgICAgICAgICAgICAgICBhcHBlbmQoJ2VuZGRpY3Qn
KTsKPj4gICAgICAgICAgICAgICAgIGVuZCBsb29wOwo+PiAgICAgICAgIGFwcGVuZCgnZW5kbGlz
dCcpOwo+PiAgICAgICAgIHJldHVybiB2X2V2ZW50czsKPj4gZW5kOwo+PiAvCj4+Cj4+IC0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQo+Pgo+PiBJIHVzZWQgdGhl
IGZvbGxvd2luZyBzY3JpcHQgdG8gY29tcGFyZSB0aGUgcGVyZm9ybWFuY2Ugb2YKPj4KPj4gICAg
ICAgICBzZWxlY3QgKiBmcm9tIHRhYmxlKHRlc3RfZXZlbnRzMikKPj4KPj4gYW5kCj4+Cj4+ICAg
ICAgICAgc2VsZWN0IHRlc3RfZXZlbnRzMiBmcm9tIGR1YWwKPj4KPj4gLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCj4+Cj4+IGltcG9ydCB0aW1lCj4+IGltcG9y
dCBjeF9PcmFjbGUKPj4KPj4gZGIgPSBjeF9PcmFjbGUuY29ubmVjdCgidXNlci9wd2RAZGIiKQo+
PiBjID0gZGIuY3Vyc29yKCkKPj4KPj4gdDEgPSB0aW1lLnRpbWUoKQo+Pgo+PiBlMSA9IFtdCj4+
IGMuZXhlY3V0ZSgic2VsZWN0ICogZnJvbSB0YWJsZSh0ZXN0X2V2ZW50czIpIikKPj4gZm9yIHIg
aW4gYzoKPj4gICAgICAgICBlMS5hcHBlbmQodHVwbGUocikpCj4+Cj4+IHQyID0gdGltZS50aW1l
KCkKPj4KPj4gZTIgPSBbXQo+PiBjLmV4ZWN1dGUoInNlbGVjdCB0ZXN0X2V2ZW50czIgZnJvbSBk
dWFsIikKPj4KPj4gb2JqcyA9IGMuZmV0Y2hvbmUoKVswXS5hc2xpc3QoKQo+Pgo+PiBmb3Igb2Jq
IGluIG9ianM6Cj4+ICAgICAgICAgZTIuYXBwZW5kKCgKPj4gICAgICAgICAgICAgICAgIG9iai5V
RV9UWVBFLAo+PiAgICAgICAgICAgICAgICAgb2JqLlVFX0JBQ0tSRUYsCj4+ICAgICAgICAgICAg
ICAgICBvYmouVUVfSU5UMSwKPj4gICAgICAgICAgICAgICAgIG9iai5VRV9JTlQyLAo+PiAgICAg
ICAgICAgICAgICAgb2JqLlVFX0lOVDMsCj4+ICAgICAgICAgICAgICAgICBvYmouVUVfTlVNQkVS
LAo+PiAgICAgICAgICAgICAgICAgb2JqLlVFX0RBVEUsCj4+ICAgICAgICAgICAgICAgICBvYmou
VUVfU1RSLAo+PiAgICAgICAgICkpCj4+Cj4+IHQzID0gdGltZS50aW1lKCkKPj4KPj4gcHJpbnQo
InRhYmxlIiwgdDItdDEpCj4+IHByaW50KCJvYmplY3QiLCB0My10MikKPj4gcHJpbnQoImVxdWFs
IiwgZTEgPT0gZTIpCj4+Cj4+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLQo+Pgo+PiBUaGUgb3V0cHV0IGlzOgo+Pgo+PiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KPj4KPj4gdGFibGUgMC40NTg1OTkwOTA1NzYxNzE5Cj4+
IG9iamVjdCAxMDYuMTQwNTE3OTUwMDU3OTgKPj4gZXF1YWwgVHJ1ZQo+Pgo+PiAtLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KPj4KPj4gaS5lLiB0aGUgb2JqZWN0
IHZlcnNpb24gaXMgMjMwIHRpbWVzIHNsb3dlciB0aGFuIHRoZSB0YWJsZSB2ZXJzaW9uLiBXaGVu
IEkKPj4gY2hhbmdlIHRoZSBudW1iZXIgb2YgaXRlcmF0aW9ucyBmcm9tIDEzMDAgdG8gMTIwMCB0
aGUgb3V0cHV0IGlzOgo+Pgo+PiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0KPj4KPj4gdGFibGUgMC40MzM2MDQ5NTU2NzMyMTc4Cj4+IG9iamVjdCAxLjI5NTY4
MzE0NTUyMzA3MTMKPj4gZXF1YWwgVHJ1ZQo+Pgo+PiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0KPj4KPj4gSSB3b25kZXIgd2h5IHRoYXQgaGFwcGVucy4KPj4K
Pj4gVGhlIGRhdGFiYXNlIHZlcnNpb24gaXMgMTEuMi4wLjEuMCBhbmQgSSdtIHVzaW5nIFB5dGhv
biAzLjYuMiB3aXRoCj4+IGN4X09yYWNsZSA2LjAuMSBvbiBNYWMgT1MgWCAxMC4xMi42Lgo+Pgo+
PiBTZXJ2dXMsCj4+ICAgIFdhbHRlcgoKU2VydnVzLAogICBXYWx0ZXIKCi0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLQpDaGVjayBvdXQgdGhlIHZpYnJhbnQgdGVjaCBjb21tdW5pdHkgb24gb25lIG9mIHRo
ZSB3b3JsZCdzIG1vc3QKZW5nYWdpbmcgdGVjaCBzaXRlcywgU2xhc2hkb3Qub3JnISBodHRwOi8v
c2RtLmxpbmsvc2xhc2hkb3QKX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX18KY3gtb3JhY2xlLXVzZXJzIG1haWxpbmcgbGlzdApjeC1vcmFjbGUtdXNlcnNAbGlz
dHMuc291cmNlZm9yZ2UubmV0Cmh0dHBzOi8vbGlzdHMuc291cmNlZm9yZ2UubmV0L2xpc3RzL2xp
c3RpbmZvL2N4LW9yYWNsZS11c2Vycwo=