After loading more than 2 million rows in our database MYSQL the query from datatables seems to crash while loading the table : is it too heavy that the plugin cannot handle the charge?
the loading of the table is stuck.
you can check the link with the table and attachement screencapture
to add a note : on the page after a a minute we have an error saying : DataTables warning: table id=table_1 - Ajax error. For more information about this error, please see http://datatables.net/tn/7
We've seen bigger tables generate through our plugin, so it shouldn't be an issue on the plugin's side. Especially since you have Server-side processing enabled (which is mandatory above 2000 rows anyway), so the plugin only pulls the rows currently displayed (10 in your case).
TN7 usually means there is some data in the table causing the issue.
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Thanks for sharing that with everyone. I will make a personal note, so if someone else reaches out with a similar problem, we may be able to fix it a lot faster.
If you have any further issues with the plugin, please feel free to open a new ticket, and we'll gladly help.
Hi there,
After loading more than 2 million rows in our database MYSQL the query from datatables seems to crash while loading the table : is it too heavy that the plugin cannot handle the charge?
the loading of the table is stuck.
you can check the link with the table and attachement screencapture
Thank you
to add a note : on the page after a a minute we have an error saying : DataTables warning: table id=table_1 - Ajax error. For more information about this error, please see http://datatables.net/tn/7
we checked the http://datatables.net/tn/7 but doesnt help with our problem.
thanks
Hello mathieu.
Thank you for your purchase.
We've seen bigger tables generate through our plugin, so it shouldn't be an issue on the plugin's side. Especially since you have Server-side processing enabled (which is mandatory above 2000 rows anyway), so the plugin only pulls the rows currently displayed (10 in your case).
TN7 usually means there is some data in the table causing the issue.
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hello again mathieu.
I logged in, and tried to create a new table with only 1 column, but the issue is still there.
You may want to try to increase the following in your php.ini file:
Although, I cannot guarantee that will work.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Aleksandar,
i did increased all but it didnt help,
although my pages are loading a bit faster now :P
Well, mathieu.
It could be an issue with your hosting provider. Can you please check with them if there are any settings they can adjust to make it load faster?
Truly, when server-side is active the plugin is pulling only visible rows, so there aren't any settings within the plugin that could help here.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Aleksandar,
thanks for the infos and your help.
I think i managed to find the solution and it might be interesting to forward the info in case someone need a fix :
the problem came from when we populated our database with the CSV files by using latin1 instead of utf8.
We switch to utf8 and all was well, so you were right, something in the data was crashing our table.
And i strongly advice to index large database : we have 10 000 000 row with 15 columns...
Cheers
Hello again Mathieu.
That is great news!
Thanks for sharing that with everyone. I will make a personal note, so if someone else reaches out with a similar problem, we may be able to fix it a lot faster.
If you have any further issues with the plugin, please feel free to open a new ticket, and we'll gladly help.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables