gogetssl / whmcs-addon

GOGETSSL WHMCS SSL Addon
MIT License
37 stars 22 forks source link

Slow WHMCS clientarea.php for user with 400+ SSL #248

Closed qhgh closed 6 months ago

qhgh commented 8 months ago

Hi there!

Our WHMCS is taking around 10 seconds to load the client area for a client with 400+ SSL.

It only happens to this user.

Do you have any ideas/advice on what we can do to speed it up?

We have converted the WHMCS db to InnoDB and optimized all tables. The host server is a rather powerful VPS with 12core and 16GB RAM. MySQL tmpdir is in tmpfs (RAM) for speed.

Thanks, C :)

vlad-evg commented 8 months ago

We will take a look on that ASAP

qhgh commented 8 months ago

We will take a look on that ASAP

Sorry I hit enter and submitted this report before I entered the details! Hope you can see it now.

vlad-evg commented 8 months ago

Hello, Do you have any environment so we can check it because we don't have an account with that many SSL certificates and adding them all will take me a lot of time.