Great, thanks Ben! Domi > Am 08.10.2013 um 09:13 schrieb Benjamin Lau <[email protected]>: > > We need to add an index to the stats.db. I mailed Kohsuke privately > that I was looking into this, but it turned out it wasn't to hard to > solve most of the problem with the addition of the following index: > > CREATE INDEX plugin_name on plugin (name); > > https://github.com/jenkinsci/infra-statistics/pull/1 > > Enjoy! > > Ben > >> On Mon, Oct 7, 2013 at 9:06 PM, Kohsuke Kawaguchi <[email protected]> wrote: >> For a while back, Domi wrote the code [1] that tallies anonymized usage >> statistics and parse them into JSON files. This is what drives the plugin >> installation count stats in Wiki. >> >> We noticed that some time ago, this started taking very long time to run >> [2]. Whereas it used to take an hour or so, now it can run upward of a whole >> day! >> >> This is causing a strain on the system, and it blocks other critical >> infrastructure jobs from running in a timely fashion. >> >> Can anyone look into the program and see what's causing the problem? Or >> perhaps rewrite it so that it can run in a realistic amount of time? >> >> >> [1] https://github.com/jenkinsci/infra-statistics >> [2] https://ci.jenkins-ci.org/job/infra_statistics/buildTimeTrend >> -- >> Kohsuke Kawaguchi >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Jenkins Developers" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/groups/opt_out. > > -- > You received this message because you are subscribed to the Google Groups > "Jenkins Developers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out.
-- You received this message because you are subscribed to the Google Groups "Jenkins Developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
