I enter data into my table by using the New Entry functionality and this works, however any field which is a Single Value selectbox or Multi Select is slow to appear.
I click on the field and there is a couple of seconds delay before the field shows up with the options to click on. These fields only have a few options i.e. usually two.
How could I speed this up as when entering 100s of entries it does get frustrating this delay as it is on 3 different fields per entry ?
The loading speed in general for all functionalities of our tables depends on a lot of factors – your hosting plan, server’s performance, amount of other data on the page, internet speed, etc.
For example, you can take a look at this SQL table on our documentation , which contains around 2.600.000 rows, and see how it loads. The more data the table has, the more chance that it will impact the loading time.
-
If your table is very small though/does not have a lot of rows and if there are only a few possible values for dropdown editing ( Selectbox/MultiSelectbox) for a Column, you can try doing this to make the dropdown load quicker.
Set the Number of possible values to load to "All" in the Data tab of this Column, then refresh the table and try to edit again - it seems to have a positive effect from my recent testing.
You can additionally try disabling the Search in select-box for editing, see if that helps it to be quicker to load the values, too.
You can download my short Video here just to see more details how that speed changes on one of our Tables.
Let me know if that perhaps helps with the dropdown value loading speed on your Table, too.
Thank you for confirming this works as intended on your end, too.
I will pass this to our QA Team and the developers, just to do further tests and to see if we can add future improvements to load these values quicker when we don't have that "All" option selected, but for now, this can be a workaround when we have a small number of unique dropdown values.
I enter data into my table by using the New Entry functionality and this works, however any field which is a Single Value selectbox or Multi Select is slow to appear.
I click on the field and there is a couple of seconds delay before the field shows up with the options to click on. These fields only have a few options i.e. usually two.
How could I speed this up as when entering 100s of entries it does get frustrating this delay as it is on 3 different fields per entry ?
Hi David,
The loading speed in general for all functionalities of our tables depends on a lot of factors – your hosting plan, server’s performance, amount of other data on the page, internet speed, etc.
For example, you can take a look at this SQL table on our documentation , which contains around 2.600.000 rows, and see how it loads. The more data the table has, the more chance that it will impact the loading time.
-
If your table is very small though/does not have a lot of rows and if there are only a few possible values for dropdown editing ( Selectbox/MultiSelectbox) for a Column, you can try doing this to make the dropdown load quicker.
Set the Number of possible values to load to "All" in the Data tab of this Column, then refresh the table and try to edit again - it seems to have a positive effect from my recent testing.
You can additionally try disabling the Search in select-box for editing, see if that helps it to be quicker to load the values, too.
You can download my short Video here just to see more details how that speed changes on one of our Tables.
Let me know if that perhaps helps with the dropdown value loading speed on your Table, too.
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
Excellent, by simply changing the dropdown for Number of possible values to load to "All" has fixed it completely.
Thanks again
Hi David,
Thank you for confirming this works as intended on your end, too.
I will pass this to our QA Team and the developers, just to do further tests and to see if we can add future improvements to load these values quicker when we don't have that "All" option selected, but for now, this can be a workaround when we have a small number of unique dropdown values.
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