Concatenated Indexes for MT
Watching to stream of commits to the MTOS repository I noticed one that intrigued me — concatenated indexes in MT objects. I asked and Brad Choate obliged me with an answer:
Prior to MT 4.1, the MT object schema never supported the declaration of concatenated indexes. Meaning, creating an index on two or more columns. Now that we can declare these, we’re making use of them, since it makes a big difference for the larger MT installations. So yes, it is significant, if you have lots of blogs with lots of entries.
This is a “wonky” sort of thing, but it will be great for performance and a prime example of the good work being done to improve the overall performance of MT in the next official release or two.
There are no comments yet. You could be the first!