Changeset 3a5476d1 in github for SQL/sqlite.update.sql

Timestamp:

Feb 23, 2011 3:13:02 AM (2 years ago)

Author:

alecpl <alec@…>

Branches:

master, HEAD, courier-fix, dev-browser-capabilities, pdo, release-0.6, release-0.7, release-0.8

Children:

041f66e

Parents:

5744bfa

Message:

• Add index on contactgroupmembers.contact_id column. Improves performance and fixes problem with contactgroupmembers table creation on MySQL 4.x

File:

• SQL/sqlite.update.sql (modified) (1 diff)

SQL/sqlite.update.sql

@@ -222 +222 @@
 
 DELETE FROM messages;
+CREATE INDEX ix_contactgroupmembers_contact_id ON contactgroupmembers (contact_id);