diff options
| author | Wil Clouser <wclouser@mozilla.com> | 2010-06-01 17:35:14 (GMT) |
|---|---|---|
| committer | Wil Clouser <wclouser@mozilla.com> | 2010-06-01 17:35:14 (GMT) |
| commit | cfb5d440431e889024fe410ae6f607006abe415b (patch) | |
| tree | 732fda2d9796897924c8546ab56feccdf81f1caf /migrations | |
| parent | 65ab1dbb6a9d8c5547235922c4737af0c53c85c7 (diff) | |
Make personas pages faster by adding indexes
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/40-personas-indexes.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/migrations/40-personas-indexes.sql b/migrations/40-personas-indexes.sql new file mode 100644 index 0000000..824d830 --- /dev/null +++ b/migrations/40-personas-indexes.sql @@ -0,0 +1,3 @@ +-- Make personas queries faster +CREATE INDEX `personas_movers_idx` ON personas (movers); +CREATE INDEX `personas_popularity_idx` ON personas (popularity); |