strange behaviour when adding location

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 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.

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