Move LQIP data from wp_options?

  • Resolved Jaro

    (@pixtweaks)


    2 years, 4 months ago

    Hi,
    It’s more a request regarding performance than an issue. We have many images and generating LQIP for most of them. I’ve noticed that LQIP Excludes files are in the wp_option table “litespeed.conf.media-lqip_exc”. In our site, it’s 311 KG large and growing.
    I would rather have another table in the database make a specific query for URL than load all as a bulk every single time.

    Thank you for the excellent job, love Litespeed <3

    Regard,
    Jaro

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Hai Zheng?

    (@hailite)

    Thanks for your review:)

    Curious why you have that many excludes LQIP data?

    Thread Starter Jaro

    (@pixtweaks)

    I don’t know, it’s been added automatically, we didn’t do it for sure.

    Plugin Support qtwrk

    (@qtwrk)

    Hi,

    could you please share few of them ?

    Best regards,

    Thread Starter Jaro

    (@pixtweaks)

    Hi,
    I looked at it closely and realised that the vast majority of URLs on this blacklist are non-existing images. They have been removed by us but probably there are still records in the DB. On some point, I can clean up DB but I’m too busy now. Not sure what’s the solution for storing blacklist in the wp_options. If there are few, makes sense, in our case it could be harmful. Maybe add a warning that “Your blacklist is unusually large”? Just a suggestion… ??

    But there are images that are working fine and I can’t see a reason to exclude them. Please check on https://pastebin.com/WTzEhBWt

    Thank you for your help!

    • This reply was modified 2 years, 4 months ago by Jaro.
    Plugin Support Hai Zheng?

    (@hailite)

    This is a good point and nice concern. We need to keep wp-options table light weight.

    Lets move it to file in the following v5.x versions.

    BTW, surprised that you have that many 404 images ??

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Move LQIP data from wp_options?’ is closed to new replies.