I recently installed LiteSpeed. It caused a page I have with a wpDataTable to run extremely slow, or produce a "critical error". The wpDataTable is doing a mySQL query. I deactivated LiteSpeed, so the page works fine now. Can you suggest anything to allow me to reactivate Litespeed? Thanks.
If you're using Excel-like tables, then you also need to go to file ..wp-content/plugins/wpdatatables/templates/frontend/excel_table_main.inc.php and around line 20 you'll find this:
Yesterday the server administrator bumped up the PHP memory_limit and that significantly sped things up. Today I implemented the fix you specified below, but I din't notice an additional change. Thank you for your help.
It seems that the fix i gave you is perhaps for an older version of our plugin, now that i double-check everything, it is possible that the developers already implemented a solution in the recent updates, so perhaps it is not as effective as it was before...
I have to check with our senior colleagues to make sure, sorry about that.
I will come back to you as soon as i get a second opinion from them. Thank you for your patience.
Apologies for such long waiting time on this confirmation.
I am still waiting to make sure and confirm it specifically for LiteSpeed plugin;
i can only say that, generally speaking, our plugin does have issues at this time, combined with caching plugins, if you use server-side processing for tables such as SQL created, and Manual tables;
The developers are intensively working to improve that behaviour, as soon as possible. We don't have an ETA on it, though.
So, of course, disabling caching for the pages where the tables are, is a temporary solution, as you already correctly pointed out;
but i will double-check if there is anything specific regarding LiteSpeed istelf.
Thank you very much for your patience, and sorry for the delay once more.
Just wanted to say i did not forget about this query, and to apologise for all the waiting time on confirmations.
-
The devs are testing to see if we have any specific advise for the LiteSpeed plugin, that might be different from other caching issues that our server-side processing is facing, still no final confirmation, but i keep checking with them, and i will do my best to confirm it as soon as possible.
The developers reported back to me regarding our query.
Unfortunately, they are not able to provide significant new information.
That is everything that we have so far about LiteSpeed cache.
Of course, you can disable caching only for pages where you have our tables; as we mentioned before.
As far as they tested , the page loads in about 10 seconds; which is not ideal, but for 84 thousand rows, it is not a bad speed.
You mentioned that the speed increased when you increased the PHP memory limit, we are certainly happy to see that, it definitely helped.
From our end, there is nothing else we can do or advise to increase the speed, at this time.
-
Our developers are intensively still working to create a solution that will fix the caching issues, but we still don't have an ETA when they will finish implementing it.
You can certainly follow our changeLog page if you'd like ( it can also be found in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
we will post a patch note when we improve caching, in one of the future updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
And my apology for accidentally copying a piece of another message at the beginning. You probably got that in your email - i have edited the message here. Sorry about that.
I recently installed LiteSpeed. It caused a page I have with a wpDataTable to run extremely slow, or produce a "critical error". The wpDataTable is doing a mySQL query. I deactivated LiteSpeed, so the page works fine now. Can you suggest anything to allow me to reactivate Litespeed? Thanks.
Hi, Kyra
Thank you for reporting this.
I believe that i found the same issue handled before, it seems that there is still a conflict between our plugin and Litespeed cache.
-
Can you please try to follow this process, and let me know if this fixes it?
-
We do not use wp_create_nonce, but wp_nonce_field, but anyway you can forward the action in their hook.
You need to go to file ..wp-content/plugins/wpdatatables/templates/frontend/table_main.inc.php and around line 21, you will find this:
Above that, add this:
If you're using Excel-like tables, then you also need to go to file ..wp-content/plugins/wpdatatables/templates/frontend/excel_table_main.inc.php and around line 20 you'll find this:
Above that line, add this:
That's how it's supposed to be done based on their instructions.
-
Let me know how it goes. Thank you
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Thank you Miloš-
Yesterday the server administrator bumped up the PHP memory_limit and that significantly sped things up. Today I implemented the fix you specified below, but I din't notice an additional change. Thank you for your help.
Hi, Kyra
Thank you for this update.
It seems that the fix i gave you is perhaps for an older version of our plugin, now that i double-check everything, it is possible that the developers already implemented a solution in the recent updates, so perhaps it is not as effective as it was before...
I have to check with our senior colleagues to make sure, sorry about that.
I will come back to you as soon as i get a second opinion from them. Thank you for your patience.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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, Kyra
Terribly sorry about the waiting time.
I am still waiting for confirmation on all the details, i will keep checking-in , and as soon as i get the information i will come back to you again.
Sorry once more for the delay.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
OK, standing by, thank you.
Hi, Kyra
Apologies for such long waiting time on this confirmation.
I am still waiting to make sure and confirm it specifically for LiteSpeed plugin;
i can only say that, generally speaking, our plugin does have issues at this time, combined with caching plugins, if you use server-side processing for tables such as SQL created, and Manual tables;
The developers are intensively working to improve that behaviour, as soon as possible. We don't have an ETA on it, though.
So, of course, disabling caching for the pages where the tables are, is a temporary solution, as you already correctly pointed out;
but i will double-check if there is anything specific regarding LiteSpeed istelf.
Thank you very much for your patience, and sorry for the delay once more.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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, Kyra
Just wanted to say i did not forget about this query, and to apologise for all the waiting time on confirmations.
-
The devs are testing to see if we have any specific advise for the LiteSpeed plugin, that might be different from other caching issues that our server-side processing is facing, still no final confirmation, but i keep checking with them, and i will do my best to confirm it as soon as possible.
Thank you very much for all the patience.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Thanks for the updates, I appreciate it.
Hi, Kyra
The developers reported back to me regarding our query.
Unfortunately, they are not able to provide significant new information.
That is everything that we have so far about LiteSpeed cache.
Of course, you can disable caching only for pages where you have our tables; as we mentioned before.
As far as they tested , the page loads in about 10 seconds; which is not ideal, but for 84 thousand rows, it is not a bad speed.
You mentioned that the speed increased when you increased the PHP memory limit, we are certainly happy to see that, it definitely helped.
From our end, there is nothing else we can do or advise to increase the speed, at this time.
-
Our developers are intensively still working to create a solution that will fix the caching issues, but we still don't have an ETA when they will finish implementing it.
You can certainly follow our changeLog page if you'd like ( it can also be found in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
we will post a patch note when we improve caching, in one of the future updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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, Kyra
And my apology for accidentally copying a piece of another message at the beginning. You probably got that in your email - i have edited the message here. Sorry about that.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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