[Plugin: WordPress Download Monitor] Why so many queries?
-
Hello!
I just installed this plugin, and my homepage went from 8 to 46 queries at once. I didn’t even add any downloads. Contact pages etc. are calling on average 38 extra queries. Is this normal?
I’m really concerned about the server load, especially with many downloads and even small traffic. Plus I will need to install a few additional plugins.
Could anyone suggest how to reduce the queries. Thanks.
-
My blog makes from ~40 to ~70 queries without this plugin.
With this plugin activated, the blog goes to ~120 queries.I do not think this is normal.
On my blog test on localhost, with this plugin not activated, I have 21 queries (with TwentyTen theme).
After activating the plugin and with no file added yet, the queries go to 61.Oh man, I hope the developer of this plugin will address this issue. I remember testing it locally a few months back and it wasn’t even close to this number of queries. It’s a pity I can’t use it as it will probably bring my site down to a crawl.
Has anyone had experience using it on a moderately busy site?
Got my account suspended because of download monitor CPU usage… =/
Could you elaborate on how this came about (too many downloads, visitors, etc.)? I suspect you’re on shared hosting, which might explains why you got kicked off.
Regardless, I think this is not a good plugin, despite the many awesome features it has. Until the issues will be fixed, there’s no way I’m going to touch it.
The developer has not yet responded to this post, but is fairly active in other threads – I guess it’s a non-issue and can be ignored?
For now I’m experimenting with other solutions and might have just found a much better alternative…
Which plugin are you using?
@aldolataldolat
Download Manager is a good and lightweight alternative, though not as customizable. It surely won’t kill your site and that’s more important than cosmetics. Personally, I gave up on all download plugins since I discovered Magic Fields a few days ago. It’s awesome as it is and they have a fairly active community, so a lot potential for for further development and improvements. I recommend you check it out.
I have ~3000 visitors a day on the website where I’m using Download Monitor, but I think something is wrong with how it counts downloads… ?
A zip file downloaded ~600 times went up to 4000 in a day ! An other one from 4000 to 7000… When I activated the stats logs, it counted a same IP address hundreds of times, even when I set the timeout to 10 or 100.
It’s really too bad because DM features are great and exactly what I need… But I can’t afford a dedicated server just to use that plugin, so I will take a look at the other plugins, thanks !
Well… I also recognized that the plugin is generating at least additional 40 queries. What´s the reason for this? Without dlm ~20 queries are made, with the plugin activated it´s more than 60!
I’ve the same problem with DLM…
My homepage went from 29 to 69 queries 🙁
It’s huge ! Why too many queries !!![9] => Array ( [0] => SELECT autoload FROM wp_options WHERE option_name = '_transient_dlm_categories' [1] => 0.0024709701538086 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, wp_dlm_clear_cached_stuff, delete_transient, delete_option ) [10] => Array ( [0] => DELETE FROM wp_options WHERE option_name = '_transient_dlm_categories' [1] => 0.0027439594268799 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, wp_dlm_clear_cached_stuff, delete_transient, delete_option ) [11] => Array ( [0] => SELECT autoload FROM wp_options WHERE option_name = '_transient_timeout_dlm_categories' [1] => 0.00090813636779785 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, wp_dlm_clear_cached_stuff, delete_transient, delete_option ) [12] => Array ( [0] => DELETE FROM wp_options WHERE option_name = '_transient_timeout_dlm_categories' [1] => 0.00073599815368652 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, wp_dlm_clear_cached_stuff, delete_transient, delete_option ) [13] => Array ( [0] => SELECT autoload FROM wp_options WHERE option_name = '_transient_dlm_tags' [1] => 0.00069713592529297 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, wp_dlm_clear_cached_stuff, delete_transient, delete_option ) [14] => Array ( [0] => DELETE FROM wp_options WHERE option_name = '_transient_dlm_tags' [1] => 0.0030219554901123 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, wp_dlm_clear_cached_stuff, delete_transient, delete_option ) [15] => Array ( [0] => SELECT autoload FROM wp_options WHERE option_name = '_transient_timeout_dlm_tags' [1] => 0.00063085556030273 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, wp_dlm_clear_cached_stuff, delete_transient, delete_option ) [16] => Array ( [0] => DELETE FROM wp_options WHERE option_name = '_transient_timeout_dlm_tags' [1] => 0.00061297416687012 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, wp_dlm_clear_cached_stuff, delete_transient, delete_option ) [17] => Array ( [0] => SELECT autoload FROM wp_options WHERE option_name = '_transient_dlm_used_tags' [1] => 0.00078105926513672 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, wp_dlm_clear_cached_stuff, delete_transient, delete_option ) [18] => Array ( [0] => DELETE FROM wp_options WHERE option_name = '_transient_dlm_used_tags' [1] => 0.00092411041259766 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, wp_dlm_clear_cached_stuff, delete_transient, delete_option ) [19] => Array ( [0] => SELECT autoload FROM wp_options WHERE option_name = '_transient_timeout_dlm_used_tags' [1] => 0.00055718421936035 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, wp_dlm_clear_cached_stuff, delete_transient, delete_option ) [20] => Array ( [0] => DELETE FROM wp_options WHERE option_name = '_transient_timeout_dlm_used_tags' [1] => 0.00078105926513672 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, wp_dlm_clear_cached_stuff, delete_transient, delete_option ) [21] => Array ( [0] => SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' [1] => 0.020756959915161 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, get_transient, wp_load_alloptions ) [22] => Array ( [0] => SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_dlm_categories' LIMIT 1 [1] => 0.0025379657745361 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, get_transient, get_option ) [23] => Array ( [0] => SELECT autoload FROM wp_options WHERE option_name = '_transient_dlm_categories' [1] => 0.00064587593078613 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, get_transient, delete_option ) [24] => Array ( [0] => SELECT autoload FROM wp_options WHERE option_name = '_transient_timeout_dlm_categories' [1] => 0.00079798698425293 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, get_transient, delete_option ) [25] => Array ( [0] => SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_dlm_tags' LIMIT 1 [1] => 0.0010530948638916 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, get_transient, get_option ) [26] => Array ( [0] => SELECT autoload FROM wp_options WHERE option_name = '_transient_dlm_tags' [1] => 0.00062417984008789 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, get_transient, delete_option ) [27] => Array ( [0] => SELECT autoload FROM wp_options WHERE option_name = '_transient_timeout_dlm_tags' [1] => 0.0006258487701416 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, get_transient, delete_option ) [28] => Array ( [0] => SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_dlm_used_tags' LIMIT 1 [1] => 0.00068902969360352 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, get_transient, get_option ) [29] => Array ( [0] => SELECT autoload FROM wp_options WHERE option_name = '_transient_dlm_used_tags' [1] => 0.00070309638977051 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, get_transient, delete_option ) [30] => Array ( [0] => SELECT autoload FROM wp_options WHERE option_name = '_transient_timeout_dlm_used_tags' [1] => 0.00080180168151855 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, get_transient, delete_option ) [31] => Array ( [0] => SELECT DISTINCT wp_download_monitor_taxonomies.id, wp_download_monitor_taxonomies.name, wp_download_monitor_taxonomies.order, wp_download_monitor_taxonomies.taxonomy, wp_download_monitor_taxonomies.parent , COUNT(wp_download_monitor_relationships.taxonomy_id) as count FROM wp_download_monitor_taxonomies LEFT JOIN wp_download_monitor_relationships ON wp_download_monitor_taxonomies.id = wp_download_monitor_relationships.taxonomy_id WHERE wp_download_monitor_taxonomies.<code>name</code> != '' AND wp_download_monitor_taxonomies.<code>id</code> > 0 GROUP BY wp_download_monitor_taxonomies.id ORDER BY wp_download_monitor_taxonomies.<code>parent</code>, wp_download_monitor_taxonomies.<code>order</code>, wp_download_monitor_taxonomies.<code>id</code>; [1] => 0.00080394744873047 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies ) [32] => Array ( [0] => SELECT taxonomy_id FROM wp_download_monitor_relationships; [1] => 0.00072193145751953 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, download_taxonomies->filter_unused_tags ) [33] => Array ( [0] => SELECT option_value FROM wp_options WHERE option_name = '_transient_dlm_categories' LIMIT 1 [1] => 0.00083780288696289 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, set_transient, get_option ) [34] => Array ( [0] => INSERT INTO <code>wp_options</code> (<code>option_name</code>, <code>option_value</code>, <code>autoload</code>) VALUES ('_transient_timeout_dlm_categories', '1308398107', 'no') ON DUPLICATE KEY UPDATE <code>option_name</code> = VALUES(<code>option_name</code>), <code>option_value</code> = VALUES(<code>option_value</code>), <code>autoload</code> = VALUES(<code>autoload</code>) [1] => 0.00066995620727539 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, set_transient, add_option ) [35] => Array ( [0] => INSERT INTO <code>wp_options</code> (<code>option_name</code>, <code>option_value</code>, <code>autoload</code>) VALUES ('_transient_dlm_categories', 'a:6:{i:2;O:17:\"download_category\":6:{s:2:\"id\";s:1:\"2\";s:4:\"name\";s:7:\"sgu-s02\";s:6:\"parent\";s:1:\"0\";s:10:\"decendents\";N;s:17:\"direct_decendents\";N;s:4:\"size\";s:2:\"20\";}i:3;O:17:\"download_category\":6:{s:2:\"id\";s:1:\"3\";s:4:\"name\";s:13:\"the-event-s01\";s:6:\"parent\";s:1:\"0\";s:10:\"decendents\";N;s:17:\"direct_decendents\";N;s:4:\"size\";s:2:\"22\";}i:4;O:17:\"download_category\":6:{s:2:\"id\";s:1:\"4\";s:4:\"name\";s:4:\"v-02\";s:6:\"parent\";s:1:\"0\";s:10:\"decendents\";N;s:17:\"direct_decendents\";N;s:4:\"size\";s:2:\"10\";}i:5;O:17:\"download_category\":6:{s:2:\"id\";s:1:\"5\";s:4:\"name\";s:4:\"v-01\";s:6:\"parent\";s:1:\"0\";s:10:\"decendents\";N;s:17:\"direct_decendents\";N;s:4:\"size\";s:2:\"12\";}i:6;O:17:\"download_category\":6:{s:2:\"id\";s:1:\"6\";s:4:\"name\";s:16:\"body-of-proof-01\";s:6:\"parent\";s:1:\"0\";s:10:\"decendents\";N;s:17:\"direct_decendents\";N;s:4:\"size\";s:1:\"8\";}i:7;O:17:\"download_category\":6:{s:2:\"id\";s:1:\"7\";s:4:\"name\";s:12:\"terra-nova-1\";s:6:\"parent\";s:1:\"0\";s:10:\"decendents\";N;s:17:\"direct_decendents\";N;s:4:\"size\";s:1:\"0\";}}', 'no') ON DUPLICATE KEY UPDATE <code>option_name</code> = VALUES(<code>option_name</code>), <code>option_value</code> = VALUES(<code>option_value</code>), <code>autoload</code> = VALUES(<code>autoload</code>) [1] => 0.0015730857849121 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, set_transient, add_option ) [36] => Array ( [0] => SELECT option_value FROM wp_options WHERE option_name = '_transient_dlm_tags' LIMIT 1 [1] => 0.00075101852416992 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, set_transient, get_option ) [37] => Array ( [0] => INSERT INTO <code>wp_options</code> (<code>option_name</code>, <code>option_value</code>, <code>autoload</code>) VALUES ('_transient_timeout_dlm_tags', '1308398107', 'no') ON DUPLICATE KEY UPDATE <code>option_name</code> = VALUES(<code>option_name</code>), <code>option_value</code> = VALUES(<code>option_value</code>), <code>autoload</code> = VALUES(<code>autoload</code>) [1] => 0.0006098747253418 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, set_transient, add_option ) [38] => Array ( [0] => INSERT INTO <code>wp_options</code> (<code>option_name</code>, <code>option_value</code>, <code>autoload</code>) VALUES ('_transient_dlm_tags', 'a:0:{}', 'no') ON DUPLICATE KEY UPDATE <code>option_name</code> = VALUES(<code>option_name</code>), <code>option_value</code> = VALUES(<code>option_value</code>), <code>autoload</code> = VALUES(<code>autoload</code>) [1] => 0.00071597099304199 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, set_transient, add_option ) [39] => Array ( [0] => SELECT option_value FROM wp_options WHERE option_name = '_transient_dlm_used_tags' LIMIT 1 [1] => 0.00074911117553711 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, set_transient, get_option ) [40] => Array ( [0] => INSERT INTO <code>wp_options</code> (<code>option_name</code>, <code>option_value</code>, <code>autoload</code>) VALUES ('_transient_timeout_dlm_used_tags', '1308398107', 'no') ON DUPLICATE KEY UPDATE <code>option_name</code> = VALUES(<code>option_name</code>), <code>option_value</code> = VALUES(<code>option_value</code>), <code>autoload</code> = VALUES(<code>autoload</code>) [1] => 0.00064897537231445 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, set_transient, add_option ) [41] => Array ( [0] => INSERT INTO <code>wp_options</code> (<code>option_name</code>, <code>option_value</code>, <code>autoload</code>) VALUES ('_transient_dlm_used_tags', 'a:0:{}', 'no') ON DUPLICATE KEY UPDATE <code>option_name</code> = VALUES(<code>option_name</code>), <code>option_value</code> = VALUES(<code>option_value</code>), <code>autoload</code> = VALUES(<code>autoload</code>) [1] => 0.00070881843566895 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks, download_taxonomies->download_taxonomies, set_transient, add_option ) [42] => Array ( [0] => SELECT * FROM wp_download_monitor_formats; [1] => 0.00081491470336914 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks ) [43] => Array ( [0] => SELECT DISTINCT meta_name FROM wp_download_monitor_file_meta; [1] => 0.0007929801940918 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks ) [44] => Array ( [0] => SELECT download_id, GROUP_CONCAT(DISTINCT taxonomy_id) AS taxonomies FROM wp_download_monitor_relationships GROUP BY download_id; [1] => 0.00089406967163086 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks ) [45] => Array ( [0] => SELECT download_id, meta_name, meta_value FROM wp_download_monitor_file_meta; [1] => 0.0014050006866455 [2] => require, require_once, require_once, require_once, do_action, call_user_func_array, wp_dlm_init_hooks )I’m using http://wordpress.org/extend/plugins/download-manager/ without any issue. try that. It’s the best one around all download management plugin.
Realized the same few hours back. Disabled it on two of my sites and saved over 60+ queries. And just realized, Download Manager has an importer for WP Download Monitor. But no use now because I have deleted the downloads from Download Monitor plugin. Anyways, I realized that I don’t need such a professional plugin for few files. Now I am tracking them via Bit.ly. Much simpler to track and no load on the site.
Have contacted the author directly via mail. Waiting for a response from him on the issue.
Got the Author’s official response:
Its been slightly tweaked since then, but I admit its still a little bit of a problem. Ideally I’ll start a new version which uses custom post types, but until then the project is on github so anyone can contribute fixes: https://github.com/mikejolley/download-monitor
Mike Jolley
So we should wait for the new version to come out. Or someone can try the dev version of the plugin from http://downloads.wordpress.org/plugin/download-monitor.zip which was last released in Jan, 2011 to check if this issue still exists or not.
- The topic ‘[Plugin: WordPress Download Monitor] Why so many queries?’ is closed to new replies.
