summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEvan Prodromou <evan@controlyourself.ca>2009-02-09 14:47:23 -0500
committerEvan Prodromou <evan@controlyourself.ca>2009-02-09 14:47:23 -0500
commit2393fbec6062da4e681b4315e89b27c934a641f1 (patch)
tree97b7549018eaf2f4278d1c63f4d11163acf860dc
parente5bad1526422f346041978a0812b0b29dc7f78bc (diff)
add some indices for performance
-rw-r--r--db/laconica.sql10
1 files changed, 7 insertions, 3 deletions
diff --git a/db/laconica.sql b/db/laconica.sql
index 012270b51..16f482134 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -258,7 +258,8 @@ create table notice_tag (
created datetime not null comment 'date this record was created',
constraint primary key (tag, notice_id),
- index notice_tag_created_idx (created)
+ index notice_tag_created_idx (created),
+ index notice_tag_notice_id_idx (notice_id)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
/* Synching with foreign services */
@@ -356,7 +357,8 @@ create table profile_tag (
constraint primary key (tagger, tagged, tag),
index profile_tag_modified_idx (modified),
- index profile_tag_tagger_tag_idx (tagger, tag)
+ index profile_tag_tagger_tag_idx (tagger, tag),
+ index profile_tag_tagged_idx (tagged)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
create table profile_block (
@@ -400,7 +402,9 @@ create table group_member (
created datetime not null comment 'date this record was created',
modified timestamp comment 'date this record was modified',
- constraint primary key (group_id, profile_id)
+ constraint primary key (group_id, profile_id),
+ index group_member_profile_id_idx (profile_id),
+ index group_member_created_idx (created)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;