Okay
  Public Ticket #1531276
get_wdtable causing 502 errors
Closed

Comments

  •  2
    Robert started the conversation

    Hi - We have had slow performance in our admin, and sometimes 502 errors. Our host (WP Engine) has said that part of this is caused by wpdatatables, in particular get_wdtable.

    They have said the following: 

    "For wpdatatables I would see if there is a setting for how often it runs the get_wdtable, and set it to as low as possible"

    Please can you advise what can be done to improve this?

    Cheers, Rob

  •  471
    Isidora replied

    Hi Robert,
    Thank you for your purchase.

    Sorry for late response,

    Please note that we have a National holiday in our country from Friday 6th to Monday 9th.

    This issue can be caused by the performance of your server and your browser. There is no settings for running action get_wdtable because when ever you make some changes on table and  click apply it will be run. We have a thousands customers running wpdatatables on different servers and it is working just fine.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables

  •  2
    Robert replied

    Hi Milan - WP Engine servers provide a good performance and we don't have this kind of issue with any of the other plugins we use. WP Engine provide very experienced support agents and have identified get_wdtable as the cause of these problems.

    The main issue is that when we have wpdatatables activated we cannot update any menus. When we save a menu change we get a 502 error. When we deactivate wpdatatables then the menu saves.

    We cannot deactivate wpdatatables every time we need to update a menu. We have also had 502s when saving posts. We have not had the time to check whether this is also because of wpdatatables but I think it is likely. It is clear that this get_wdtable function is causing problems and needs to be improved. 

    When you say "There is no settings for running action get_wdtable because when ever you make some changes on table and  click apply it will be run. " - are you saying that this action only runs when changing a wpdatatable table, or is this any table in the wp database?

    There may be other customers who are experiencing an issue because of this but were unable to identify it. We were only able to identify it because of WP Engine.

    Cheers, Rob

  •  471
    Isidora replied

    HI Robert,

    Our plugin is based on Datatables jquery plugin and this get_wdtable is required function. With server-side processing enabled, all paging, searching, ordering actions that DataTables performs are handed off to a server where an SQL engine (or similar) can perform these actions on the large data set (after all, that's what the database engine is designed for!). As such, each draw of the table will result in a new Ajax request being made to get the required data.

    We are not sure how is related saving post or menu with our tables, because our plugin is including files only on pages where you use wpdatatables shortcode or in back-end when you making tables. You are the first customer that wrote to us throw our support system with this kind of issue.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables

  •  2
    Robert replied

    Hi Milan - Thanks for the further information. I'm confused because I can only pass on what WP Engine are telling me. We will have to find someone who understands it better to investigate further so I will let you know if we get more detail.

    Cheers, Rob

  •  471
    Isidora replied

    HI Robert,

    Let me know if you have more details about this.

    Best regards.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables