Okay
  Public Ticket #3741300
Saving Issue
Closed

Comments

  • BERHAN SONER started the conversation

    I have table with 40 columns and 300+ rows. When I try to change settings of a column and hit save changes button, very frequently I see the rotating circle for a very long time. I have waited over 5 mins and than I had to refresh the page. This happens very frequently. 

  • BERHAN SONER replied

    When transform value feature is used in more than 1 column, the page gets frozen and the rows won't load




  •  1,851
    Miloš replied

    Hello,

    Can you tell me what is your table type - Is it a table linked from a Spreadsheet like CSV/Excel or similar?

    Or are you using a server-side- processing table, such as a Manual table or SQL query based?

     

    I will advise you about slow load issues in our Plugin in general, how that can happen and what you can do to resolve it ( it depends on the table type, but we will cover all scenarios) :

    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.

    Please note that Table is an SQL Query Based Table, it uses our Server-Side Processing feature, which dramatically improves loading speeds by using AJAX to only load one Table page at a time,

    compared to non-server-side Tables which always load all rows on the HTML of the Page regardless of Table Pagination.

     

     

    If you use non-server side Tables, like linked from Google Spreadsheet/CSV/Excel , we advise trying our cache and Auto Update Cache feature.

    With our caching option, the load time is significantly lowered, but we still recommend keeping the data in these files down to around 5.000 rows.

    If any of your Table linked from source file goes above that size - then the best is to switch to SQL based Tables, to import the data from CSV/Google Sheet or Excel.

     

     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 :

     

     

    You can also check, in this table's filter settings for columns, how many unique filtering values there are.

    If you have, for example - a string column that you set as a selectbox/multiselectbox, 

    and if it has more than 50 possible filtering values,

    you can go into that column setting, and check what is set for "Number of possible values to load" – 

    Here you can define how many possible values per page will be loaded in selectbox filter and editor inputs. It is recommended not to be set for All if you have more than 50 possible values for this column.

    2095790605.png
    1309831925.png

    So, check if that might be the case, try to lower the value to 50 and see if it helps the speed.

    -

     

    Also, it is possible for other plugins to affect the loading speed.

    We had a couple of cases with users who have an "optimization plugin" with specific settings, 

    such as  'SiteGround Optimizer', for example.

    These plugins have certain settings that can negatively affect the performance of our tables.

    If there is any JS minification going on,  there can be other settings, I can't say exactly,

    but something to be aware of.

    If you wish to do troubleshoot testing to check if an optimization/caching plugin might be slowing down tables,

    you can try to disable all plugins and just leave wpDataTables active - then clear all cache and reload the page, see if it loads faster.

     

    Then, if any optimization plugin Is used, try to revert all its settings to default, and if you use server-side tables ( such as SQL or Manual tables) ,  then exclude the pages where you have tables from caching.

     

     

    Another thing to consider is how many 'Default rows per page' are set in the Display settings.

    2392875160.png

    Try setting this as low as possible and test if that improves performance for that table.

    I recommend it is best to use our new 'Custom rows per page', so if you allow front-end users to be able to use the dropdown for Rows per page on front-end, this will limit their options, to avoid loading 'All rows' and if you wish to get as much performance as possible, you can even remove the 100 and 50 options, or even 25 if that helps. 

    8251761984.png

     

     

    Check if you have the "auto-refresh" enabled on the Tables.

    7850453827.png

     

    If you have a large number of tables and enabled this at a high frequency, such as every 5 or 10 seconds, then the Hosting Server will often make Admin-Ajax calls from the Hosting Server to the SQL Database to pull the data, which can increase the server's load.

    You can try disabling it and see if that helps.

     

    Lastly, if you use an external Database connection ( not the default WordPress database), in some cases it can help the performance if you can move those SQL tables to pull them directly from the same DB where WordPress is on the Hosting server, so you can try that as well.

     

    That is about all the advice i can give about this, but of course, let us know if you have additional questions. Thank you.

     

    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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

  • BERHAN SONER replied

    Hi


    I have a manually created table consisting of 46 columns and 307 rows.

    Here are the issues I have experienced in 2 days.

    1- I applied Transform value to one integer column (<a href="tel:{kontaktel.value}">{kontaktel.value}</a>) Cause I wanted the phone number to be clickable.

    Works properly

    I did the same to another integer column <a href="tel:{stkontakcep.value}">{ stkontakcep.value}</a>

    But no matter how long I wait the table won't load until I delete/cancel the transform value.


    2- I wanted the users to be able to edit their own rows. But since the table was created by me not by them I have added a column and named it User ID for assigning the rows to various users. But in standard view it was taking too long to edit 303 rows of User ID column one by one. So I switched to excel view which was faster than standard view to edit the rows. But then I realized that the input of another column was mostly gone. Only few of the phone numbers were left. Luckily I had a back up of the table and I could manage to load it again. I guess there is a bug while editing in excel View. 


    3- On the editing tab of the subject table I checked the Limit Editing Own Data only. And configured the User ID column setting as userid which I mentioned above. However when the user logs in and opens the page (front-end) he/she can see only his/her rows. What I need is that the users can see the entire rows but can edit only those assigned to them (created by them). Or at least - as the administrator- I want to see/edit the entire table on the front-end. There's an option for See all rows for this table in admin area but it would be great if I could see/edit them on the front-end. Really appreciate if you advise me a way to do it. If not available please consider it for the next update 🙃


    4- Regardless of the above issues, when the table works properly if I want to display the All rows (which is only around 300) the entire page freezes (not only the table). I have to close or refresh the page. (I tried once again before sending this email. The page froze again but after waiting around 1-2 mins it displayed all rows) Maybe it is related with my server settings. Please advise if anything that I can ask the provider to resolve this issue.


    If needed I can provide you with admin login credentials.


    Thanks in advance for your  kind assistance