Large media library support?

  • Resolved Dan Greene

    (@dgreene423)


    9 months, 4 weeks ago

    I support a motorsports news website that has a very large media library; 34,000 images along with 37,922 posts. Can the plugin handle that many images? How much size/load would the isc_post_images and isc_image_posts meta and the isc_index table potentially add to the database?

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Thomas Maier

    (@webzunft)

    9 months, 4 weeks ago

    Hi Dan,

    thanks for reaching out.

    I am not aware of an issue on large websites. When I learn about a potential issue with them, I fire up my dedicated test sites with 30k posts and images.

    isc_post_images and isc_image_posts are serialized arrays. There is one per image and one per post. The entry is usually not that long and small compared to the meta data WordPress core itself stores for images and posts.

    The isc_index table stores one entry per image in a post content. On my small test site I have 199 lines and the table is 48KB small. Scaled up to 30k lines, that would be a lower MB size.

    All relevant fields are indexed and many information are cached so they wouldn’t be written on an uncached website and should be fast even with a lot of images.

    You can use the Query Monitor plugin to see if any ISC queries are slow on your site and then I can take a closer look.

    Thanks,
    Thomas

    Thread Starter Dan Greene

    (@dgreene423)

    9 months, 3 weeks ago

    Thanks for your reply @webzunft, that definitely answered my question. I’ll pass this info along to the site’s photography editor.

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

The topic ‘Large media library support?’ is closed to new replies.

Tags