Dear WP Download Manager Pro Team,
please forward this to your developer team.
We are currently debugging our sites performance, and according to “Query Monitor” the WPDM plugin is adding a lot of page load time by executing a lot of SQL queries. On our page with 12 download packages, it is sending 121 SQL queries which accumulates to 515MS added time to page load.
The 12 downloads are with the Gutenberg block. The template is not displaying any statistics of number of previous downloads, but it seems the plugin is fetching statistics for every download block, adding 12 uncached sql queries and 242MS of TTFB time alone. (Please see my attached screenshot).
Secondly, there are 60 SQL queries to wp_comments table adding another 97MS of TTFB. These queries are also completely unnecessary for us – we don’t allow comments.
Thirdly, query monitor also warns about duplicate queries when fetching the download data itself from wp_postmeta.
Please see our attached screenshots.
We are looking forward hearing from you.
Best,
Leonhard
Screenshot 1: https://snipboard.io/jBhpbD.jpg – Query Monitor Slow Query Warning
Screenshot 2: https://snipboard.io/HU0aZu.jpg – WPDM adding 246MS of TTFB for statistics
Screenshot 3: https://snipboard.io/jKEDfp.jpg – WPDM adding 97MS of TTFB for 60 queries to WP Comments
Screenshot 2: https://snipboard.io/s4N9XV.jpg – WPDM adding 515MS of TTFB altogether
PS: This is our Template:
<div class=”wp-block-download-manager-panel w3eden wpdm-sa wpdm-sa-many”>
<div class=”card card-default panel panel-default”>
<div class=”card-header panel-heading collapsed” data-toggle=”collapse” href=”#wpdm-[version]”>
<div class=”title” style=”color:#333333″>[description]</div>
</div>
<div class=”card-body panel-body collapse” id=”wpdm-[version]”>
<div class=”d-all”>[icon] Download all ([package_size]) [download_link]</div>
<div class=”content”>[file_list]</div>
</div>
<div class=’panel-footer’></div>
</div>
</div>
I would encourage you to have default columns of at least post title and download button so your block works out of the box. Nothing is displayed if the download button column is not added. So it should be in by default.
Additionally, the columns section doesn’t like having two columns with titles next to them. One gets deleted. you have to put them in between columns with no title for them to stay. After a save and reload of the block editor you can add another or move them next to each other. You might want to look into that.
Finally thought, why can’t I edit an existing column and give it a title. Why do I have to delete it and put it back in?
I feel like these are more bug reports than a feature request, but this is where your forum sent me.
I tried to use your All Downloads Table block on a site and it never displayed any downloads but the available downloads count was correct. To rule out any other features I installed the plugins on a fresh local install of WordPress with your Attire theme and the problem was duplicated. I don’t see any errors in the console, but the grey area between the filter button and the total downloads is empty.
Dropping in the shortcode [wpdm_all_packages] works fine and displays all downloaded packages installed.
6.7.2 Download Manager Pro
2.3.0 Gutenberg Blocks
We have spotted an issue with listing downloads within xml sitemaps when using Yoast pro. As the site is very large we’ve used the yoast code snippet (https://yoast.com/help/xml-sitemaps-in-the-wordpress-seo-plugin/ via wpseo_sitemap_entries_per_page) to limit the number of pages per sitemap (as they simply take too long to render once you get above 1k pages). This works for all pages and content types other than the download manager sitemaps. We have 5 x DM site maps but four of them are blank. Any hope would be appreciated
Hi, I have recently moved from the Pro version to the Free version as the site is slowly fading away so I don’t want to send much on it, but I must have been using a Pro template before because now the download links are not showing, just some sort of shortcode [files]. So I want to change all the downloads from whatever it was to Extended as that suits my needs. I have over 200 downloads so I dont want to have to do this manually on each one, so I thought I could just edit the database, but I can’t find where the template is set. I’m fully ok with editing databases and using myPHP, but I just need to know where to change it, can you advise where this setting is in the database?
Thanks!