[WebERP-developers] Database Maintenance at Logon Fails Regularly

[baliboss <it...@ba...>]

Dear, All webERP Developers and Phil Daintree

In our webERP System Configuration (version 4.10.1), we set the Perform
Database Maintenance At Logon to Monthly and there is no problem for more
than 3 years now.

But now when the first user login every month and performing the database
maintenance, the process seems like stuck and loading for hours, no error
messages, it's just loading. It's happen for several months now. We thought
it's stuck so we decide to change the config in phpmyadmin and set
DB_Maintenance to '0' (never)  and cancel the process, clear the browser
cache and webERP running as usual.

What we want to know is:
1. What's the script actually do? which DB table affected by this script?
2. Is the script really necessary to run in webERP? Is there's any problem
if we set it to '0' (never)?
3. Is it possible that this issues happens because our database is growing
larger and larger each months? If it's really the issues, so how we manage
to perform the database maintenance properly?

Thank You,

Best Regards, 
----------------
Ade / baliboss



-----
Baliboss
Bali Open Source Solution
www.baliboss.com
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Database-Maintenance-at-Logon-Fails-Regularly-tp4658349.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.