Important Database Pagination!

[Burti]

A customer has 60,000 domain names of his own. However, the browser crashes because there is no paging in the database query. How can I find a solution?

[WHMCS John]

Hi @Burti,

That's a lot of domains!

Do you observe the problem in the client area or the admin area?

Which version of WHMCS are you running?

[Burti]

On 9/22/2023 at 2:39 PM, WHMCS John said:

Hi @Burti,

That's a lot of domains!

Do you observe the problem in the client area or the admin area?

Which version of WHMCS are you running?

 

Hi John! Sorry for my late reply. 

Too little domain for a rich man 🙂

I'm using latest version. I have problem in client area.

[Burti]

Hello can we have any updates on development?  @WHMCS John

[WHMCS John]

Hi @Burti,

I do see the same behaviour in my benchmark testing with such a massive volume of domain records.

This is definitely the highest I've ever encountered in a single client account, so I've opened a case internally to enable us to begin tracking  how common this is.  If this is a scenario that WHMCS users start to experience more frequently, we could potentially explore what options might be available to increase performance for such massive datasets in the DataTables jQuery plugin which renders the list.

In the meantime, perhaps consider splitting the domains between multiple Client Accounts? A single User can be the Owner of all the Client Accounts and so switch between them with the same set of login credentials.