Optimize MySQL queries for SolusVM database to make UI work faster
Consider to optimize MySQL queries for SolusVM database.
The two examples below:
Index on vserverid field in bandwidthstatistics table can improve performance of the cron script for bandwidth reset scheduled task
If there are about 55 pages of IP Blocks, 64 IPs per block it cannot render the page with pagination 'All' due to timeout that caused by intensive mysql query.
Miguel Ângelo commented
Agreed. Furthermore, if you allow me to add, the IP block page needs to be optimized further, it's currently a mess to search for subnets there. You can use the general search function but still, not ideal.