I will advise you on multiple scenarios, the most important question is, what are the types of your tables?
- do you use multiple tables on the same Page;
- And what is the total number of rows on your page which has the slow load.
There is a big difference if you use tables "linked from existing data source" or "importing data from a data source".
I will advise on both cases.
If you use an Excel/CSV/Google Sheet or similar as the source for the tables - can you please tell me how many rows does the source Sheet have?
( Or if you place multiple tables on the same Page, how many rows approximately are in total combined from used tables);
The same rules apply to charts - Each charts draws the rows from its source table.
If the table does not use our server-side processing, then all the rows are pulled in the Chart, thus on your HTML of the Page at the same time.
For example, if it has more than around 5 to 6 thousand rows - you might be reaching the current PHP limits of the Hosting Server ( such as PHP timeOut limit).
1. When you try to link a Table from a source file like a Google Sheet/CSV or Excel; during this process, the plugin needs to read the entire data set coming from the spreadsheet for the initial table creation.
For this, it takes a certain time interval ( depending on how large the data set is).
So, what you can try is to increase the max_execution_time and max_input_time ( or in other words, to increase the timeout limit in php.ini file),
This way, it should prevent the table creation wizard from breaking until the table is generated.
-
When the table successfully generates on the back-end, if you wish to have improved performance, you can try enabling our cache and auto-load cache , in the table settings,
but the plugin needs to have enough time for the server to process everything/ to read the full data set of the spreadsheet and table.
-
If you want to check what is the current configuration, you can do this from our Plugin's Dashboard, in System Info Tab.
And check the PHP Memory Limit.
If it is only 128 MB, we recommend increasing it to at least 256 or 512 MB which should be enough for most websites ( depending how many other Plugins and data you plan to have on the site, etc).
Let me know if that helps.
Or, if your file goes over 6 thousand rows, then the best choise 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 :
This table will use our server-side processing and it will have drastically better loading time performance on your Page(s).
3. Additional advice about slow load :
The loading speed depends on a lot of factors - your hosting plan, server's performance, amount of other data on the page, internet speed, etc.
For example, you can take a look at the table on our documentation, which contains around 2.600.000 rows, and see how it loads. The more data the table has, the more chance that it will impact the loading time, but it shouldn't be as drastic as it is on your end.
I hope that helps, let me know how it goes.
If you still see any errors in the browser Console, please send me an URL of the page where you have one or more Tables, and we can advise you - and also please confirm what is the table type.
If it needs a logged user, you can send us the credentials, just make sure it is a PRIVATE reply - then only we can see it, for security.
BONJOur
quand j'inclue des tableaux ou des graphiques dans mes pages
ça ralentit beaucoup la page et google search console me met la page en erreur
avez-vous une solution svp ?
sinon cela veut dire qu'il faut que je désinstalle votre plug in
Hi Benedict,
I will advise you on multiple scenarios, the most important question is, what are the types of your tables?
- do you use multiple tables on the same Page;
- And what is the total number of rows on your page which has the slow load.
There is a big difference if you use tables "linked from existing data source" or "importing data from a data source".
I will advise on both cases.
If you use an Excel/CSV/Google Sheet or similar as the source for the tables - can you please tell me how many rows does the source Sheet have?
( Or if you place multiple tables on the same Page, how many rows approximately are in total combined from used tables);
The same rules apply to charts - Each charts draws the rows from its source table.
If the table does not use our server-side processing, then all the rows are pulled in the Chart, thus on your HTML of the Page at the same time.
For example, if it has more than around 5 to 6 thousand rows - you might be reaching the current PHP limits of the Hosting Server ( such as PHP timeOut limit).
1. When you try to link a Table from a source file like a Google Sheet/CSV or Excel; during this process, the plugin needs to read the entire data set coming from the spreadsheet for the initial table creation.
For this, it takes a certain time interval ( depending on how large the data set is).
So, what you can try is to increase the max_execution_time and max_input_time ( or in other words, to increase the timeout limit in php.ini file),
This way, it should prevent the table creation wizard from breaking until the table is generated.
-
When the table successfully generates on the back-end, if you wish to have improved performance, you can try enabling our cache and auto-load cache , in the table settings,
but the plugin needs to have enough time for the server to process everything/ to read the full data set of the spreadsheet and table.
-
If you want to check what is the current configuration, you can do this from our Plugin's Dashboard, in System Info Tab.
And check the PHP Memory Limit.
If it is only 128 MB, we recommend increasing it to at least 256 or 512 MB which should be enough for most websites ( depending how many other Plugins and data you plan to have on the site, etc).
Let me know if that helps.
Or, if your file goes over 6 thousand rows, then the best choise is to switch to importing this data to an editable/SQL based Table.
2. 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 :
This table will use our server-side processing and it will have drastically better loading time performance on your Page(s).
3. Additional advice about slow load :
The loading speed depends on a lot of factors - your hosting plan, server's performance, amount of other data on the page, internet speed, etc.
For example, you can take a look at the table on our documentation, which contains around 2.600.000 rows, and see how it loads. The more data the table has, the more chance that it will impact the loading time, but it shouldn't be as drastic as it is on your end.
I hope that helps, let me know how it goes.
If you still see any errors in the browser Console, please send me an URL of the page where you have one or more Tables, and we can advise you - and also please confirm what is the table type.
If it needs a logged user, you can send us the credentials, just make sure it is a PRIVATE reply - then only we can see it, for security.
Thank you.
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