Nesooo Posted October 10, 2017 Share Posted October 10, 2017 Hi, why is invoice cancellation extremely slow, our setup is on dedicated server, not load, large amount of RAM, optimized, MariaDB etc. only slowdown is when invoices are canceled, it can take over 30-60 seconds and nothing else can be done until this process is done. Is this related maybe to MariaDB or we missing something else or it is general problem with WHMCS when you have larger set of clients, we have around 1500+ 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Developer WHMCS Andrew Posted October 10, 2017 WHMCS Developer Share Posted October 10, 2017 How are you cancelling the invoice? I am going to guess using the "Mark Cancelled" option from a list of invoices. Depending on how many invoices you are cancelling at a time, this is a simple operation. Update status in tblinvoices to cancelled Log an item in the Activity Log Run the InvoiceCancelled hook This will run for *each* invoice you are cancelling at the time. Do you have any hooks running, using this hook point that could be causing the slowdown? 0 Quote Link to comment Share on other sites More sharing options...
Nesooo Posted October 22, 2017 Author Share Posted October 22, 2017 Yes, 1 hook causing problem, this can be marked as solved. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.