High-loaded Project

Hello!

I have a project which contains 3 activities, every which contains about 85 activities and every last which contains 21 activities and 13 milestones.

I try to delete it.


When I do this on a test server, it's all good (to tell the truth, it takes about 40 minutes). But when I try to do this on a remote server, I'll got errors.



Php and mySQL configs are same on both servers. The test server is running on Apache, the remote server is running on IIS.

Maybe, should I edit additional settings/configuration for correct work?

Thank You in advance

this deleting first sub-activities to split the deletion in several operations

Yes, I can, but it will be more useful to delete in a one click. And when I try to delete a part of the project - an activity which contains 45 activities every which contains 21 activities and 13 milestones - Projeqtor could not delete it. But if I delete an activity which contains only 30 activities every which contains 21 activities and 13 milestones, Projeqtor will return same errors (the screenshot is in a previous message) and if after that I update page, activity is deleted.

Of maybe you are in safe mode, which forbids to overwrite max_execution_time dynamically.

In "php.ini" sql.safe_mode is off. Or did You tell about other safe mode?

Try and configure max_execution_time.

max_execution_time is 3600 in both servers' settings.

You may have reached Time limit Timeout.

I changed innodb_lock_timeout from 50 to 500 in "my.ini" and after that I got error again. Maybe do You mean other timeout? (work_timeout is 60)

It's not big deal to spent many time, while Projeqtor delete items, but it is very important, what it delete items without any errors.

It you created so many item, why delete them ?

Because I have few same subprojects, and for faster work of planning (Gannt) I have deleted a subproject, which is already done. So work is more comfortable to me.

Try and change max_execution_time to very high value (10000 for instance)

It did not help, unfortunately.

Thank You for help. I'll research this question further