Changeset 1856

Timestamp:

04/11/08 04:33:08 (22 months ago)

Author:

bchoate

Message:

Removing class_author index since we don't select (system-wide) entries by author. It is also confusing the MySQL optimizer in some cases, ignoring the class+authored_on index.

Files:

• branches/release-34/lib/MT/Entry.pm (modified) (1 diff)

branches/release-34/lib/MT/Entry.pm

@@ -64 +64 @@
             columns => [ 'blog_id', 'class', 'author_id', 'authored_on' ],
         },
-        class_author => {
-            columns => [ 'class', 'author_id', 'authored_on' ],
-        },
         # For optimizing weekly archives, selected by blog, class,
         # status.