That amount of data is not an issue whatsoever if you're using the database - creating an SQL query based table. I wouldn't recommend creating a table linked to an existing data source (CSV), simply because it is too large.
If you have access and at least basic knowledge of MySQL, you can import the CSV file into the database, and create a new table there from that file.
Then, you can create the table in wpDataTables like:
SELECT * FROM mytable
And when you decide to add a few thousand rows more, you simply import the CSV in the database again (only this time you wouldn't be creating a new table, but instead import only new entries under the table you created previously).
We need to load (we are hosting on AWS) a csv with 50 columns and at least 70,000 rows of data.
Is there a way to enable to a large amount of data to be loaded through the plugin directly?
Or do you have a suggestion as to any easy way to otherwise load this amount of data?
Please note from time to time we also expect to need to add to the database with an additional few thousand rows of data.
Hello commtogether.
Thank you for your interest in our plugin.
That amount of data is not an issue whatsoever if you're using the database - creating an SQL query based table. I wouldn't recommend creating a table linked to an existing data source (CSV), simply because it is too large.
If you have access and at least basic knowledge of MySQL, you can import the CSV file into the database, and create a new table there from that file.
Then, you can create the table in wpDataTables like:
And when you decide to add a few thousand rows more, you simply import the CSV in the database again (only this time you wouldn't be creating a new table, but instead import only new entries under the table you created previously).
I hope this helps.
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