I'm using wpdatatables to display an excel database of 25 000 wine informations. The table takes about 5 secondes to show up and the search feature is very laggy (2 secondes between each letter when typing in the search bar).
This is all probably due to the fact that the whole 25 000 rows are being loaded and searched.
Do you think there is a way to make it all smoother ? Maybe by transfering the xlsx excel data onto the wordpress database ? Or maybe in the setting ?
Also I would like to know if it's possible to link the dataTables to Forms. I know it's possible with gravity forms, but would it be ok with other froms plugins ? Like the SuperForms plugin.
For a table this big, we do advise either converting to CSV, or even better - creating a database table like you mentioned.
That way the table only reads what's currently being displayed on the page with the help of Server-Side processing, and thus making it a lot smoother.
As for the Forms plugin - we do have integration with Formidable forms, as well, but along with Gravity - that is all. We currently do not have plans to integrate with other Form plugins.
Hello sorry to bother you,
I'm using wpdatatables to display an excel database of 25 000 wine informations. The table takes about 5 secondes to show up and the search feature is very laggy (2 secondes between each letter when typing in the search bar).
This is all probably due to the fact that the whole 25 000 rows are being loaded and searched.
Do you think there is a way to make it all smoother ? Maybe by transfering the xlsx excel data onto the wordpress database ? Or maybe in the setting ?
Also I would like to know if it's possible to link the dataTables to Forms. I know it's possible with gravity forms, but would it be ok with other froms plugins ? Like the SuperForms plugin.
Best regards,
Simon Biasotto
Hello Simon.
For a table this big, we do advise either converting to CSV, or even better - creating a database table like you mentioned.
That way the table only reads what's currently being displayed on the page with the help of Server-Side processing, and thus making it a lot smoother.
As for the Forms plugin - we do have integration with Formidable forms, as well, but along with Gravity - that is all. We currently do not have plans to integrate with other Form plugins.
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