Promising plugin but freezes on sites with very large amount of pages

I had high hopes for this plugin but am a little disappointed. I installed it on our client’s content rich site with over 10k posts/pages. After running the initial scan for several hours it froze, and after doing some debugging I found it was erroring while trying to write an extremely large value to a single field in the database. This massive value (almost 40mb) was an aggregation of all the site’s page’s post_content. Looking at the plugin code, it seems the purpose for this is to run a str_contains check over that aggregation of content for the attachment file name value to check if it’s inserted directly into a page.

This approach might work most sites, but it’s not a viable approach for larger sites like ours. Making the plugin unusable for us.

One of the USPs of this plugin is that it claims to smartly search the page and post content for the attachments. That’s why we considered purchasing it. Maybe if they improve this aspect it will be a truly great plugin and we will revisit for our clients.

To the plugin developers: I’d suggest using a batch process to check each attachment file individually with a query like:

SELECT COUNT(id) FROM wp_posts WHERE post_content LIKE '%ATTACHMENT_NAME%';

instead of trying to match against all post content at once. It would take longer to execute, but could run in the background and would work for sites like ours.