There might be many answers to your questions. Looks like a database tuning problem, or a resource problem in your server. Have you checked your CPU usage in your server? Are other users able to work with OpenERP?

Hello,

Please chage your server configuration file with following.

# Specify the number of workers, 0 disable prefork mode.
workers = 0

# Maximum allowed virtual memory per worker, when reached the worker be reset after the current request (default 671088640 aka 640MB)
limit_memory_soft = 671088640

# Maximum allowed virtual memory per worker, when reached, any memory allocation will fail (default 805306368 aka 768MB)
limit_memory_hard = 805306368

# Maximum allowed CPU time per request (default 60)
limit_time_cpu = 60

# Maximum allowed Real time per request (default 120)
limit_time_real = 120

# Maximum number of request to be processed per worker (default 8192)
limit_request = 8192

Check Link for more.

Thanks,

Nimesh.

All the MRP work with browse object ... that SO SO SLOW, read all field in a record and use only a few, MRP module need to be re-write to avoid use of browse. My Little Opinion