Too much SQL updates

  • eir3apps

    (@eir3apps)


    1 year, 6 months ago

    Hello,

    what’s up with all these SQL updates that the plugin makes? On opening the “New Post” page, there are 22 SQL updates by the Lightbox plugin. Why is that? Can it be reduced?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor LightPress

    (@pandaboxwp)

    1 year, 6 months ago

    They are sql queries, not updates, but I’ve otherwise confirmed this – and on dashboard page, not just new post page. I believe it is related to autoloading of plugin options. I’ll look at cleaning that up in the next week. I recently took this plugin over from the long-time owner, and I hadn’t actually checked or looked at this. So thanks for the report!

    Thread Starter eir3apps

    (@eir3apps)

    1 year, 6 months ago

    No, those are updates. Here’s one of them:

    INSERT INTO lt_options (option_name, option_value, autoload)
    VALUES ('lightpress_active_lightbox', 'wp-jquery-lightbox', 'auto')
    ON DUPLICATE KEY
    UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    Thanks for looking into this! Much appreciated!

    Josh Journey

    (@ljosh)

    1 year, 2 months ago

    Checking in regarding this.

    Plugin Author Firelight

    (@firelightwp)

    1 year, 2 months ago

    Hey @ljosh – I haven’t resolved this yet. I’ll bump it on the priority list. Thank you for following up.

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

The topic ‘Too much SQL updates’ is closed to new replies.