Martijn Pieters wrote:
On 11/24/06, Yuri <yurj@alfa.it> 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/inserimento 2.3416 5.5694 8.7971 8.7971, 2.3416 8.7971 was the time without subtransactions, 2.3 with. Ops... -.-