Major problem of (over) load server in BO of 1.5 RC

[Dev On Web]

Hi all,

 

Since my last post (it goes up a little), a project under PS 1.5 has been completed and put into production (yes, with an RC!).

 

Everything works pretty good, especially in FO. The trouble lies in the back office. It appears that when the project seems a bit too ambitious: 10 shops in multishop mod it's ok but it with 150? Omg...

 

Let me explain:

 

SQL queries performed in the BO, especially those for the interface management products, are quite monstrous (IN SELECT heavily in increasingly enormous as each other).

 

Up to lead to an extreme concern: forced to cut access to the BO! If an employee goes on the management interface products and is attempting any change, the server will experience a peak load which will almost certainly down (whatever its size). The rate of requests per second then exploded at once (from 10 to over 2000!).

 

The server then completely crash and a restart is required. The CPU and memory being overloaded.

 

It seems requests that the management system or product is not suitable for a variety of shops. It would be good to warn people of these limits. One can certainly optimize queries of BO and prevent the loading of information products from all the shops (which crasherait server immediately upon opening the soundtrack), but this does not solve the underlying problem. The amendment to the unity of a multi-boutique product is always a problem ...

 

For now, forget to share back office and ban its use to manage products, no solution.

 

Has anybody come across this trouble or am I the only one who tested the 1.5 RC with a large number of shops?

 

Thank you.