Re: [Fwd: Re: [Zope] help performance]
Martijn Pieters wrote: On 11/24/06, Yuri <[EMAIL PROTECTED]> wrote: 8.7971 was the time without subtransactions, 2.3 with. Ops... -.- Indeed. And if you tweak the threshold as Jonathan suggested, you could even get it lower. Just to clarify, 2.3 sec is the time to insert only one object :) I'll try to tweak it as suggested by you gurus :P ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Fwd: Re: [Zope] help performance]
On 11/24/06, Yuri <[EMAIL PROTECTED]> wrote: 8.7971 was the time without subtransactions, 2.3 with. Ops... -.- Indeed. And if you tweak the threshold as Jonathan suggested, you could even get it lower. -- Martijn Pieters ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Fwd: Re: [Zope] help performance]
Martijn Pieters wrote: On 11/24/06, Yuri <[EMAIL PROTECTED]> wrote: > and *enable* subtransactions! When I have a transaction wich takes almost 1 sec, I don't think it will change anything :) I'll try CallProfiler :) Did you try? Subtransactions are not the same as transactions. They are an optimization, so try them! Don't just ditch the experts here. 0.0209 0.9%| +0.0209 0.0174 0.7%+- inserimento +0.0320 0.0042 0.2%| +- standard_html_header +0.0337 0.0017 0.1%| | +- intestazione_html_standard +0.0374 0.0011 0.0%| | +- mappa_barra_loggato +0.0423 1.0951 46.8% | +- dafne_item_add 0.5836 24.9% | | | +0.6260 0.0028 0.1%| | +- proprietario +0.6301 0.0484 2.1%| | +- sonopubblico +0.6804 0.0026 0.1%| | +- proprietario (2nd call) 0.0406 1.7%| | | +0.7236 0.0043 0.2%| | +- globale 0.4665 19.9% | | | +1.1945 0.0457 2.0%| | +- sonopubblico (2nd call) +1.2423 0.0033 0.1%| +- invalida_cache +1.2468 0.0010 0.0%| +- standard_html_footer Ok, I've run a machine for three years without any optimizations. Enabling transaction cut the time of about 73%: http://myurl/inserimento2.3416 5.5694 8.7971 8.7971, 2.3416 8.7971 was the time without subtransactions, 2.3 with. Ops... -.- ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] help performance
Martijn Pieters wrote: On 11/24/06, Yuri <[EMAIL PROTECTED]> wrote: > and *enable* subtransactions! When I have a transaction wich takes almost 1 sec, I don't think it will change anything :) I'll try CallProfiler :) Did you try? Subtransactions are not the same as transactions. They are an optimization, so try them! Don't just ditch the experts here. ok, you got me :) with callprofiler I have: +0.0209 0.1213 1.4%+- inserimento +0.0461 0.0044 0.1%| +- standard_html_header +0.0479 0.0018 0.0%| | +- intestazione_html_standard +0.0518 0.0012 0.0%| | +- mappa_barra_loggato 0.0931 1.1%| | +0.1467 7.4849 85.1% | +- dafne_item_add 1.1709 13.3% | | | +1.3175 0.0027 0.0%| | +- proprietario +1.3245 0.0450 0.5%| | +- sonopubblico 0.1486 1.7%| | | +1.5181 0.0026 0.0%| | +- proprietario (2nd call) 1.3108 14.9% | | | +2.8316 0.0043 0.0%| | +- globale 4.6964 53.4% | | | +7.5323 0.0452 0.5%| | +- sonopubblico (2nd call) 0.1539 1.7%| | | +7.7324 0.0367 0.4%| +- invalida_cache +7.7704 0.0010 0.0%| +- standard_html_footer What does exactly take 4.6 sec? :-o ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] help performance
On 11/24/06, Yuri <[EMAIL PROTECTED]> wrote: > and *enable* subtransactions! When I have a transaction wich takes almost 1 sec, I don't think it will change anything :) I'll try CallProfiler :) Did you try? Subtransactions are not the same as transactions. They are an optimization, so try them! Don't just ditch the experts here. -- Martijn Pieters ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] help performance
Yuri wrote: When I have a transaction wich takes almost 1 sec, I don't think it will change anything :) You might be surprised... Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] help performance
Andreas Jung wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 - --On 24. November 2006 11:20:39 +0100 Andreas Jung <[EMAIL PROTECTED]> wrote: ZopeProfiler will tell you about bottlenecks. Doesn't work in zope 2.6 based on python 2.1 :( Try CallProfiler instead. and *enable* subtransactions! When I have a transaction wich takes almost 1 sec, I don't think it will change anything :) I'll try CallProfiler :) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] help performance
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 - --On 24. November 2006 11:20:39 +0100 Andreas Jung <[EMAIL PROTECTED]> wrote: >> >>> >>> ZopeProfiler will tell you about bottlenecks. >>> >> >> Doesn't work in zope 2.6 based on python 2.1 :( >> > > Try CallProfiler instead. > and *enable* subtransactions! - -aj -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (Darwin) iD8DBQFFZsfJCJIWIbr9KYwRAn4EAJ9NDvAQT4jOEcBSOEshEWz/I6EtEwCfepEK tPE8sMBxMQET/euEhCVAD5g= =FztJ -END PGP SIGNATURE- ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] help performance
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 - --On 24. November 2006 11:16:50 +0100 Yuri <[EMAIL PROTECTED]> wrote: >>> >>> >> >> ZopeProfiler will tell you about bottlenecks. >> > > Doesn't work in zope 2.6 based on python 2.1 :( > Try CallProfiler instead. - -aj - -- ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376 E-Publishing, Python, Zope & Plone development, Consulting -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (Darwin) iD8DBQFFZsd3CJIWIbr9KYwRAkt2AKCssal5dASk5L2Hr5Hx25NcP73HlACfd8sR zwcPSLgP0kd/wyMVPCtV4oU= =lx7b -END PGP SIGNATURE- ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] help performance
Andreas Jung wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 - --On 23. November 2006 17:07:39 +0100 Yuri <[EMAIL PROTECTED]> wrote: Hi! I've an old machine with zope 2.6 with an application based on ZClass. Now, updating 4000 record takes ages (more than an hour...), basically it is a propertysheet update + recatalog of every object of 4000. Can I have significative performance upgrade changing something in the code base? Some ZCatalog "slow" bug in 2.6 I could patch you know of? :) ZopeProfiler will tell you about bottlenecks. Doesn't work in zope 2.6 based on python 2.1 :( # more version.txt 1.7.2 for Zope 2.5.1 and 2.6.1, 2.7.3, 2.8, 2.9 Python 2.3.x, 2.4.x ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] help performance
Jonathan wrote: - Original Message - From: "Yuri" <[EMAIL PROTECTED]> To: Sent: Thursday, November 23, 2006 11:07 AM Subject: [Zope] help performance Hi! I've an old machine with zope 2.6 with an application based on ZClass. Now, updating 4000 record takes ages (more than an hour...), basically it is a propertysheet update + recatalog of every object of 4000. Can I have significative performance upgrade changing something in the code base? Some ZCatalog "slow" bug in 2.6 I could patch you know of? :) You could try different transaction subcommit threshold settings (Catalog - Advanced tab) to see if different settings have any beneficial impact. Subtransactions are *Disabled :) * ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] help performance
- Original Message - From: "Yuri" <[EMAIL PROTECTED]> To: Sent: Thursday, November 23, 2006 11:07 AM Subject: [Zope] help performance Hi! I've an old machine with zope 2.6 with an application based on ZClass. Now, updating 4000 record takes ages (more than an hour...), basically it is a propertysheet update + recatalog of every object of 4000. Can I have significative performance upgrade changing something in the code base? Some ZCatalog "slow" bug in 2.6 I could patch you know of? :) You could try different transaction subcommit threshold settings (Catalog - Advanced tab) to see if different settings have any beneficial impact. Jonathan ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] help performance
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 - --On 23. November 2006 17:07:39 +0100 Yuri <[EMAIL PROTECTED]> wrote: > Hi! > > I've an old machine with zope 2.6 with an application based on ZClass. > Now, updating 4000 record takes ages (more than an hour...), basically it > is a propertysheet update + recatalog of every object of 4000. > > Can I have significative performance upgrade changing something in the > code base? Some ZCatalog "slow" bug in 2.6 I could patch you know of? :) > ZopeProfiler will tell you about bottlenecks. - -aj -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (Darwin) iD8DBQFFZce2CJIWIbr9KYwRAjMFAKCje2mf4XN4z/loynCUMo+MIW4cSwCfUnUA dH8pNs+4XK2yrzjJ+sfVWlQ= =1Uee -END PGP SIGNATURE- ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] help performance
Hi! I've an old machine with zope 2.6 with an application based on ZClass. Now, updating 4000 record takes ages (more than an hour...), basically it is a propertysheet update + recatalog of every object of 4000. Can I have significative performance upgrade changing something in the code base? Some ZCatalog "slow" bug in 2.6 I could patch you know of? :) TIA ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )