I am managing a SQL data table of 83,096 entries on the part list page of my website. Google is only indexing the front page of the table, and I've seen in other tickets that it's likely due to having to use server side processing and AJAX requests. So, as a more general question, does wpDataTables have the capacity to manage what I need? I need all entries to show up on google. I need to maintain efficient website speed and not have the page crash when loaded. If there are any referencable examples of wpDatatables that work this way I would love to see.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
I am truly sorry to disappoint you, but at the moment, we do not have a valid solution for server-side tables with such a large data set to have all rows crawlable for Google SEO ( without breaking the page).
You are correct, it is due to server-side processing using AJAX to only load the rows which are on the first page of the table.
-
Tables are crawlable by search engines, but they are somewhat limited.
Manual, imported, and MySQL query-based tables with server-side processing enabled will only show the content of the 1st page.
For example, if you set that the table shows 10 rows per page, by default, Google and other search engines will only be able to see that page, while the other pages won't be crawlable.
Linked tables (Excel, CSV, Google Spreadsheet, XML, JSON, and PHP tables) are fully crawlable since they fetch all the rows, output the entire table to the front-end all at once, and then split it into pages using JavaScript; all data processing (page switching, sorting, filtering) is done on the client’s computer by JavaScript.
-
For example, if you had a much smaller table, let's say around 5, 6 thousand rows, you could do a workaround by editing a few lines of plugin code,
to increase the "allowed number of rows" for server-side processing toggle, ( the default limit where we force server-side is 2 thousand rows)
and to disable server-side on SQL Tables, then Google SEO would crawl all the rows,
but even for that a very high performance hosting server with high PHP limitation settings would be needed.
-
You can suggest an improvement suggestion for our developers, they will do their best to work on improving that in the future.
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
I am managing a SQL data table of 83,096 entries on the part list page of my website. Google is only indexing the front page of the table, and I've seen in other tickets that it's likely due to having to use server side processing and AJAX requests. So, as a more general question, does wpDataTables have the capacity to manage what I need? I need all entries to show up on google. I need to maintain efficient website speed and not have the page crash when loaded. If there are any referencable examples of wpDatatables that work this way I would love to see.
Hi, Austin.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
I am truly sorry to disappoint you, but at the moment, we do not have a valid solution for server-side tables with such a large data set to have all rows crawlable for Google SEO ( without breaking the page).
You are correct, it is due to server-side processing using AJAX to only load the rows which are on the first page of the table.
-
Tables are crawlable by search engines, but they are somewhat limited.
Manual, imported, and MySQL query-based tables with server-side processing enabled will only show the content of the 1st page.
For example, if you set that the table shows 10 rows per page, by default, Google and other search engines will only be able to see that page, while the other pages won't be crawlable.
Linked tables (Excel, CSV, Google Spreadsheet, XML, JSON, and PHP tables) are fully crawlable since they fetch all the rows, output the entire table to the front-end all at once, and then split it into pages using JavaScript; all data processing (page switching, sorting, filtering) is done on the client’s computer by JavaScript.
-
For example, if you had a much smaller table, let's say around 5, 6 thousand rows, you could do a workaround by editing a few lines of plugin code,
to increase the "allowed number of rows" for server-side processing toggle, ( the default limit where we force server-side is 2 thousand rows)
and to disable server-side on SQL Tables, then Google SEO would crawl all the rows,
but even for that a very high performance hosting server with high PHP limitation settings would be needed.
-
You can suggest an improvement suggestion for our developers, they will do their best to work on improving that in the future.
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
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