{"id":63,"date":"2012-05-30T13:59:13","date_gmt":"2012-05-30T13:59:13","guid":{"rendered":"http:\/\/blog.mozilla.org\/nfroyd\/?p=63"},"modified":"2012-05-30T13:59:13","modified_gmt":"2012-05-30T13:59:13","slug":"slow-sql-in-xpcshell-testing","status":"publish","type":"post","link":"https:\/\/blog.mozilla.org\/nfroyd\/2012\/05\/30\/slow-sql-in-xpcshell-testing\/","title":{"rendered":"slow sql in xpcshell testing"},"content":{"rendered":"<p>One of the best things about performance monitoring is that it sometimes shows up problems in very unexpected areas.\u00a0 Yesterday while working on some <a href=\"https:\/\/bugzilla.mozilla.org\/show_bug.cgi?id=748517\">improvements to telemetry<\/a>, I noticed that the telemetry packets being sent had information for <tt>slowSQLStartup<\/tt>.\u00a0 That is, there were some SQL queries (4 of them, to be exact; 3 unique queries) that were taking more than 150 ms to run just during xpcshell testing.<\/p>\n<p>These queries were run by the addons manager and already have <a href=\"https:\/\/bugzilla.mozilla.org\/show_bug.cgi?id=729330\">a bug on file<\/a>.<\/p>\n<p>I&#8217;m guessing that this slow SQL does not occur during all xpcshell tests, but only those that create a profile (about 5% of tests). which would translate into ~1% of xpcshell testing time.\u00a0 Still, speedups are speedups, and fixing these queries would be a good speedup for Firefox users generally.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of the best things about performance monitoring is that it sometimes shows up problems in very unexpected areas.\u00a0 Yesterday while working on some improvements to telemetry, I noticed that the telemetry packets being sent had information for slowSQLStartup.\u00a0 That is, there were some SQL queries (4 of them, to be exact; 3 unique queries) [&hellip;]<\/p>\n","protected":false},"author":320,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.mozilla.org\/nfroyd\/wp-json\/wp\/v2\/posts\/63"}],"collection":[{"href":"https:\/\/blog.mozilla.org\/nfroyd\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.mozilla.org\/nfroyd\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.mozilla.org\/nfroyd\/wp-json\/wp\/v2\/users\/320"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.mozilla.org\/nfroyd\/wp-json\/wp\/v2\/comments?post=63"}],"version-history":[{"count":0,"href":"https:\/\/blog.mozilla.org\/nfroyd\/wp-json\/wp\/v2\/posts\/63\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.mozilla.org\/nfroyd\/wp-json\/wp\/v2\/media?parent=63"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.mozilla.org\/nfroyd\/wp-json\/wp\/v2\/categories?post=63"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.mozilla.org\/nfroyd\/wp-json\/wp\/v2\/tags?post=63"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}