I've got my Wpdatatables working the way I want, except for the slow speed.
I see the WPdatatabable demos and they load at lightening speed compared with my site.
I've read all I can find on speeding up my WPDatatables - tried Swift, W3 Cache, Smuch Pro CDN - but I must be missing something as none of these have made any real improvement to my datatables .
My site has OK speed (95% and 4.2sec loading according to GTMetrix)
But my tables take 10+ seconds to load and even simple dropdown lists in the Entry pop up also take several seconds.
Some of my WPDataTables use SQL with one or two joins but even when I test drive a simple wpdatatable with no sql joins its no faster.
Does anyone have any suggestions for where I look for answers?
How many rows do these tables have in the database? If the tables are filtered from a big database table (or combination of tables), the plugin takes time to go through them all and filter what's needed on site.
So, speed mostly depends on your server performance and hosting plan, but it can be impacted by the size of the table. For the drop-down list to load faster, go to Column settings/Data, and change "Number of possible values to load" from 10 to All.
I'm on a business hosting plan and the database tables only have tens of rows right now, not even hundreds. My sql does join 3 tables, but even when I try a simple table with just a few rows and no SQL joins the load time is still slow.
The MySQL view (as explained in the previous ticket) can help you with the speed a little, but I don't believe it will.
Every server-side table (MySQL, manual, imported) sends an admin-ajax request, and the response is in JSON. So, each call and response take around 1 second to complete. Multiply that with the number of charts and tables, and you'll have the long loading times like you explained.
If you have less than 2.000 entries, you can turn off server-side processing, which should speed everything up, but if you have more than 2.000 entries, server-side will be turned on automatically.
Thanks - FYI, I have converted all my non-front end editable tables and charts to simple queries to Views, but as we thought, it has not resulted in any speed benefit. Thanks anyway.
I've got my Wpdatatables working the way I want, except for the slow speed.
I see the WPdatatabable demos and they load at lightening speed compared with my site.
I've read all I can find on speeding up my WPDatatables - tried Swift, W3 Cache, Smuch Pro CDN - but I must be missing something as none of these have made any real improvement to my datatables .
My site has OK speed (95% and 4.2sec loading according to GTMetrix)
But my tables take 10+ seconds to load and even simple dropdown lists in the Entry pop up also take several seconds.
Some of my WPDataTables use SQL with one or two joins but even when I test drive a simple wpdatatable with no sql joins its no faster.
Does anyone have any suggestions for where I look for answers?
Hello Andrew
How many rows do these tables have in the database? If the tables are filtered from a big database table (or combination of tables), the plugin takes time to go through them all and filter what's needed on site.
So, speed mostly depends on your server performance and hosting plan, but it can be impacted by the size of the table. For the drop-down list to load faster, go to Column settings/Data, and change "Number of possible values to load" from 10 to All.
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
Thanks Aleksander
Yes the dropdowns are instant now - great tip!
I'm on a business hosting plan and the database tables only have tens of rows right now, not even hundreds. My sql does join 3 tables, but even when I try a simple table with just a few rows and no SQL joins the load time is still slow.
Any other suggests on what I might try?
Andrew
Nothing comes to mind why your tables would be slow, then, Andrew
Can you show me on which pages are the tables located, and also - provide me a temporary wp-admin user, so I can log in, and check the plugin?
I can't promise anything, but I will try.
Please note that this is a public ticket, so make sure to enable the PRIVATE response.
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 again Andrew
The MySQL view (as explained in the previous ticket) can help you with the speed a little, but I don't believe it will.
Every server-side table (MySQL, manual, imported) sends an admin-ajax request, and the response is in JSON. So, each call and response take around 1 second to complete. Multiply that with the number of charts and tables, and you'll have the long loading times like you explained.
If you have less than 2.000 entries, you can turn off server-side processing, which should speed everything up, but if you have more than 2.000 entries, server-side will be turned on automatically.
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
Thanks for your time Aleksander - yes this is what I feared, and I think if I use Views I may also have trouble saving data back to the tables.
But I will take all your good advice and try a few things.
Your support is greatly appreciated.
Feel free to close this ticket.
Andrew
You're welcome, Andrew
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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
Thanks - FYI, I have converted all my non-front end editable tables and charts to simple queries to Views, but as we thought, it has not resulted in any speed benefit. Thanks anyway.
You're welcome Andrew
Sorry I couldn't be of any more help.
If you decide to explore this issue further, and find there was something within wpDataTables causing this, please reach out to me.
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