jenkinsci/infra-statistics — pull request #1 by netjunki (2013-10-08 07:13:26+00:00)
Title: Generate an index on the plugin names so generating the list of unique n...

This should create the necessary index when creating the database initially, but since the database has already been created the existing stats.db needs to either have the following command run on it manually:

CREATE INDEX plugin_name on plugin (name);

or it should be deleted and allowed to regenerate... that process only took about 20 minutes on my Mac Pro laptop. Either way this will make the select query to get the unique list of plugin names run significantly faster.