Forums / Developer / strange behaviour when adding location
Marko Žmak
Wednesday 15 February 2006 8:21:23 am
I have a serious problem with adding new locations to objects in eZ. It generates a huge amount of SQL queries and overloads the server, the script crashes. The problem is described here:
http://ez.no/community/forum/setup_design/strange_behaviour_with_adding_location
-- Nothing is impossible. Not if you can imagine it! Hubert Farnsworth
Thursday 16 February 2006 7:59:12 am
Does anyone know any sollution about this?
Adding locations to objects is crucial for my site, so my site is uselles without it. Please help!
Juan Pablo Vercesi
Thursday 16 February 2006 8:35:58 am
Could you tell what are the queries about? Maybe that way it's possible to find out what's going on.
Have you customized ez code?
JP, may the source be with you.
Paul Borgermans
Thursday 16 February 2006 10:31:47 am
Hi Marko,
I tried this on a similar system (ezp 3.7.3, php 4.4). Adding many locations is indeed a CPU and query intensive process (here 1.8 secs for adding 4 locations at the same time, 102 SQL queries, all caches off, template compiling off, .... but its a fast machine ... has to be with Exponential).
Try increasing the memory limit for php
--paul
eZ Publish, eZ Find, Solr expert consulting and training http://twitter.com/paulborgermans
Friday 17 February 2006 6:25:42 am
No, i didn't customize eZ code. The machine I'm hosting my pages is Dual Xeon2.4Ghz. The execution od mysql queries lasts 6 seconds for adding 4 locations on this machine.
I'll do some more testing and send the queries here on the forum.
I also tried increasing php memory limit but it didn't help. And even if I increase it more and the script stops to crash, this doesn't solve my problem, since adding object to several locations at once is a crucial part of the user interface of my site.
Maybe I'm just naive, but I don't see a reason why so many queries are needed for adding several locations at once. I bet it can be optimized.