I am hoping to use wpdatatables to create a table that will have 30,000 rows. Is there a limit to the number of rows wpDatatables allows? If so is there a way to get around it?
Please check out this documentation page to see how a table we made from 2.560.000 loads,
and you will also find explanations for making large SQL tables there.
-
And i just wanted to point out that you can try wpDataTables before purchasing
on our sandbox Demo sites ( you can find links for the main plugin Demo,
as well as add-on Demos, in my signature),
and there is a 15-day money-back guarantee period,
so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)
Data that has more than few thousand rows can sometimes not be imported in this way directly via the plugin ( depending on the server) - this is a limitation that is coming from WordPress itself combined with server performance.
But there is a solution.
What you can do is, if you get errors, and it does not work importing directly through our plugin,
you can then import the file, in form of Excel, CSV, or spreadsheet directly in your database via your database management tool, such as PhPMyAdmin.
And then you will be able to create a simple SQL query based table from this database table, by using this query (for example):
SELECT * FROM table_1
Let me know if that helps.
On our Demo, you will not be able to try this - because you won't have access to our Site's SQL Database;
But on your own Website, you will easily be able to import your file in your SQL Database via your DB Management Tool;
Then just make an SQL Query Table with our Plugin like : SELECT * From Imported_Table_Name
Hello,
I am hoping to use wpdatatables to create a table that will have 30,000 rows. Is there a limit to the number of rows wpDatatables allows? If so is there a way to get around it?
Hi, Corey.
Thanks for reaching out to us.
wpDataTables plugin does not have a limit for rows,
but depending on the hosting server for WordPress, the server itself will have limitations.
We have a server-side processing feature that can help when you have very large data sets ( approximately , more than 5000 rows),
for these situations, we recommend using our SQL-based tables with server-side processing enabled.
These tables can be Manual Tables,
and SQL Query based tables.
You can also import data from CSV/Excel or Google Sheets to make new Manual Tables.
And you can update existing Manual tables by uploading CSV/Excel or Google Spreadsheets.
-
Please check out this documentation page to see how a table we made from 2.560.000 loads,
and you will also find explanations for making large SQL tables there.
-
And i just wanted to point out that you can try wpDataTables before purchasing
on our sandbox Demo sites ( you can find links for the main plugin Demo,
as well as add-on Demos, in my signature),
and there is a 15-day money-back guarantee period,
so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)
Let me know if you have any additional 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
Please see the table I just created with your Sandbox Hosting and it is still showing error as below
Can you suggest me what causes this problem?
Attached files: Screenshot 2023-11-21 225408.png
Hi Kazi,
Do you have a CSV or Excel/ or Google Sheet file which you tried to import, and it has 30,000 rows?
If that is the case, we can explain what is happening.
In regards to importing the data via a file,
Data that has more than few thousand rows can sometimes not be imported in this way directly via the plugin ( depending on the server) - this is a limitation that is coming from WordPress itself combined with server performance.
But there is a solution.
What you can do is, if you get errors, and it does not work importing directly through our plugin,
you can then import the file, in form of Excel, CSV, or spreadsheet directly in your database via your database management tool, such as PhPMyAdmin.
And then you will be able to create a simple SQL query based table from this database table, by using this query (for example):
SELECT * FROM table_1
Let me know if that helps.
On our Demo, you will not be able to try this - because you won't have access to our Site's SQL Database;
But on your own Website, you will easily be able to import your file in your SQL Database via your DB Management Tool;
Then just make an SQL Query Table with our Plugin like : SELECT * From Imported_Table_Name
Let me know 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