Handling large dataset on Datatables: Page 2

SalKhattak · 2022-02-22T14:54:43+00:00

All, I have about 12,000 stores. Now when I login to the admin dashboard & click on stores, I am getting the error below. Please advise, DataTables wa...

Handling large dataset on Datatables

[deleted]

SalKhattak I want to give you a suggestion

Check mysql max connections. Set it to at least 2000-2500 if you are using a VPS.
Check php max_input_time and max_execution_time set both to 300
Max memory limit to your server ram
max_vars to 20000.

Then check.

SalKhattak

[deleted] I will suely give it a shot before vacating the VPS sir & provide feedback. Thank you sir.

SalKhattak

[deleted] Saurabh the solution you suggested worked. Foodomaa is working as a champ now. I can clearly see the performance issues with my VPS now, I just need a better underlying infrastructure to run the system.

Check mysql max connections. Set it to at least 2000-2500 if you are using a VPS.
Check php max_input_time and max_execution_time set both to 300
Max memory limit to your server ram

max_vars to 20000. (I set this to 25000)

SalKhattak

babyseya follow the solution suggested by Saurabh [deleted]

Saurabh

SalKhattak then the issue is with the server not able to handle such large data.

SalKhattak

thank you sir, I should be able to set things up in AWS within the next 24 to 48. It will be setup to take whatever load possible & prvide you with some cloudwatch insight that maybe helpful to my fellows :-)

babyseya

HI!, I also have the same situation as you currently, I have sent it to the support team but that party said because I deleted the data in the database, (I'm sure I never went to the database to delete anything) and now at the current state still unresolved!
If you have solved the above situation, please guide me

Saurabh

babyseya
Support team will never tell you that you have deleted data unless you have actually done that.

Tell me your ticket ID and I will post the screenshot here 🙂

[deleted]

SalKhattak Happy to help as always 😃

babyseya

Saurabh I still can't do it now, and still have the same error, because now I have a lot of data, but support said I have to install from scratch 🙁 is there any way to help me?

SalKhattak

babyseya , how many records are you trrying to import at once? The best solution I found was to limit the stores to 2,000 per bulk import. Also make sure you upload all the images to the server first before trying to import.

Let me know if you still need help.

« Previous Page