strange behaviour when adding location

Author Message

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

Marko Žmak

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!

--
Nothing is impossible. Not if you can imagine it!

Hubert Farnsworth

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 ez publish).

Try increasing the memory limit for php

--paul

eZ Publish, eZ Find, Solr expert consulting and training
http://twitter.com/paulborgermans

Marko Žmak

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.

--
Nothing is impossible. Not if you can imagine it!

Hubert Farnsworth

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.