Data Publisher page using high CPU & unresponsive

  • Resolved marcodisco

    (@marcodisco)


    5 years, 10 months ago

    Hi Peter,

    Thanks for your work on this plugin – it has helped me to quickly create a proof-of-concept for a new project.

    I am raising an issue about the Data Publisher list page from the main WP Data Access menu. To be clear, the issue is with the WP Data Access->Data Publisher page, and not the display of my data in the actual publication.

    I have 3 items already on this page. When I show the page, the list displays quickly and is immediately responsive.

    Today I added a new entry to the page. The entry relates to a DB table with 5000+ existing records. By default, ‘paging’ is off for new data publisher entries.

    When I display the list page again (Data Publisher page from the main WP Data Access menu) I found that the 4 items displayed quickly, but the page was unresponsive for 30-45 seconds or so – with high CPU on my PC.

    I think that somehow the list page is parsing all of the DB records that match the publication before the page becomes responsive.

    I switched on paging for my new publication & saved it. Now the Data Publisher list is quick and responsive again – which seems to confirm that number of DB records is important here.

    Thanks,
    Mark

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years, 10 months ago

    Hi Mark,

    With version 3.1.5 the structure of the publication table was changed. Unfortunately, the default values for searching, ordering and paging were switched to disabled. Since this involves the default values for these columns only, you’ll experience this problem with new publications only. Existing publications (created with an earlier release) will not have this problem.

    You did the right thing: enable searching, ordering and paging. 👍

    I have already patched the current version (3.1.5). You can update your release, but you have to delete the plugin first.

    Be carefull when you delete the plugin!!! Make sure your publications, projects and plugin settings are not deleted!
    – Go to menu Settings
    – Sub menu WP Data Access
    – Tab Uninstall
    – Uncheck both checkboxes
    – Save your setting
    With these settings you can delete and re-install the plugin without losing your data. Deleting the plugin folder with ftp works as well!

    You can also enable searching, ordering and paging like you did before…

    Thank your for reporting this bug. Sorry for the inconvenience! 🙈

    Best regards,
    Peter

    Thread Starter marcodisco

    (@marcodisco)

    5 years, 10 months ago

    Thanks for the quick response Peter.

    I understand what you have said, and see that I have a way to make the list responsive.

    From a technical standpoint, I don’t see why the number of records in my DB table should affect your page which is essentially a list of what is in your plugins publication table.

    Regards,
    Mark

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years, 10 months ago

    Hi Mark,

    The list table allows shortcode testing It does that by fetching the first page for every publication on the page in advance. It’s not a nice solution, I know! I have to improve that some day…

    Hope this makes more sense… 🙂
    Peter

    Thread Starter marcodisco

    (@marcodisco)

    5 years, 10 months ago

    OK, that makes sense.

    Thanks Peter.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Data Publisher page using high CPU & unresponsive’ is closed to new replies.