Skip to content
← Help us Improve Solus

How can we improve current and future versions of solus?

Help us Improve Solus: Admin & User Interface

Categories

(thinking…)

Optimize MySQL queries for SolusVM database to make UI work faster

Consider to optimize MySQL queries for SolusVM database.

The two examples below:

  1. Index on vserverid field in bandwidthstatistics table can improve performance of the cron script for bandwidth reset scheduled task

  2. 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.

6 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Nikolay Zhmuk shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Miguel Ângelo commented  ·   ·  Report

    Hi,

    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.