I will advise you on potential solutions, our Plugin can easily handle a couple thousand rows.
Can you confirm, when you are creating a Table from this data set, I presume you are choosing "Create a data table linked to an existing data source"?
For tables between 2 and 5 thousand rows, if you wish to have improved performance, you can try enabling our cache and auto-load cache , in the table settings, this should help.
Let me know if you have any questions about that feature or if you struggle with any step setting it up for your tables.
-
In the future, if your file goes over 6 thousand rows, then the best choice is to switch to importing this data to an editable/SQL based Table.
Once the table is created, it is no longer linked to the source file, so changing data in the table will not show up in Excel or Google Spreadsheet, and vice-versa.
To modify this table, you can either switch to the Excel-like view,
and then select and copy the range of cells you want to paste from the source file, and paste it in the Excel-like view,
or you can import a new/edited CSV to update the table, as well, in the following ways :
If you switch to these imported/SQL based Tables, then you will use our server-side(lazy load) processing feature, which dramatically helps with loading performance.
Let me know how it goes and if you have any questions.
We are loading too many rows above 2000 so our page is takes to much of time to load. We use csv file for loading
Hello,
I will advise you on potential solutions, our Plugin can easily handle a couple thousand rows.
Can you confirm, when you are creating a Table from this data set, I presume you are choosing "Create a data table linked to an existing data source"?
For tables between 2 and 5 thousand rows, if you wish to have improved performance, you can try enabling our cache and auto-load cache , in the table settings, this should help.
Let me know if you have any questions about that feature or if you struggle with any step setting it up for your tables.
-
In the future, if your file goes over 6 thousand rows, then the best choice is to switch to importing this data to an editable/SQL based Table.
If you import the file, the plugin reads the source file and creates a manual table.
Once the table is created, it is no longer linked to the source file, so changing data in the table will not show up in Excel or Google Spreadsheet, and vice-versa.
To modify this table, you can either switch to the Excel-like view,
and then select and copy the range of cells you want to paste from the source file, and paste it in the Excel-like view,
or you can import a new/edited CSV to update the table, as well, in the following ways :
If you switch to these imported/SQL based Tables, then you will use our server-side(lazy load) processing feature, which dramatically helps with loading performance.
Let me know how it goes and if you have any questions.
Kind Regards,
Miloš Jovanović
[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