{"action":"closed","issue":{"url":"https://api.github.com/repos/wpmudev/multi-db/issues/2","repository_url":"https://api.github.com/repos/wpmudev/multi-db","labels_url":"https://api.github.com/repos/wpmudev/multi-db/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/wpmudev/multi-db/issues/2/comments","events_url":"https://api.github.com/repos/wpmudev/multi-db/issues/2/events","html_url":"https://github.com/wpmudev/multi-db/issues/2","id":131151295,"number":2,"title":"Huge amount of redundant queries with WPMU Dev dashboard latest version","user":{"login":"mrbm","id":391043,"avatar_url":"https://avatars.githubusercontent.com/u/391043?v=3","gravatar_id":"","url":"https://api.github.com/users/mrbm","html_url":"https://github.com/mrbm","followers_url":"https://api.github.com/users/mrbm/followers","following_url":"https://api.github.com/users/mrbm/following{/other_user}","gists_url":"https://api.github.com/users/mrbm/gists{/gist_id}","starred_url":"https://api.github.com/users/mrbm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mrbm/subscriptions","organizations_url":"https://api.github.com/users/mrbm/orgs","repos_url":"https://api.github.com/users/mrbm/repos","events_url":"https://api.github.com/users/mrbm/events{/privacy}","received_events_url":"https://api.github.com/users/mrbm/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-02-03T21:00:21Z","updated_at":"2016-02-03T23:02:30Z","closed_at":"2016-02-03T23:02:30Z","body":"I posted about this issue here:  https://premium.wpmudev.org/forums/topic/bug-updating-latest-dashboard-not-working\r\n\r\nUsing the plugin: https://wordpress.org/plugins/query-monitor/ I reviewing the queries\r\n\r\nGoing through the queries...this DUPLICATE query is seen repeating itself over and over again (697 times):\r\n\r\n`UPDATE 'wp_sitemeta' SET 'meta_value' = '' WHERE 'site_id' = 1 AND 'meta_key' = '_site_transient_wdp_un_local_projects'`\r\n\r\nGoing through more of the queries...this DUPLICATE query is seen repeating itself over and over again (698 times):\r\n\r\n```\r\nUPDATE wp_sitemeta \r\nSET meta_value = '(ALL MY PLUGIN/THEME SUFF IN HUGE IDENTICAL JSON ENCODED STRING)'\r\nWHERE site_id = 1\r\nAND meta_key = '_site_transient_wdp_un_local_projects'\r\n```\r\nIf I do a search in all the 1513 queries for the string\r\n`WHERE site_id= 1 AND meta_key= '_site_transient_wdp_un_local_projects'`\r\n\r\nI get 1393\r\n\r\n...soo....i think i found a way to help the developers find their problems...perhaps they could make sure they are testing with multi-db in a multi-site environment. Wondering if this issue is also why WPMU Dev MarketPress is getting such high query counts and performing so slow."}}