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).
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
You must be logged in to post messages in this topic!