[Fwd: Re: [Zope] help performance]

2006-11-24 Thread Yuri


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: [Fwd: Re: [Zope] help performance]

2006-11-24 Thread Martijn Pieters

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 )


Re: [Fwd: Re: [Zope] help performance]

2006-11-24 Thread Yuri

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 )