* Bryan Tong Minh <bryan.tongminh(a)gmail.com> [Thu, 2 Dec 2010 19:38:47
+0100]:
On Thu, Dec 2, 2010 at 6:23 PM, Dmitriy Sintsov
<questpc(a)rambler.ru>
wrote:
So probably the core patch is
the only efficient way to solve my problem?
You can always supply a database patch with your extension to add
indices you need to core tables.
Indices are not hard to add, that's true. However, even with indexes the
GROUP BY rev_text_id query on large revision set is slow. I probably
will have to patch Revision::newNullRevision to add a new field value
there (for the existing it is possible to fill the new field with
UPDATE, however there will be new null revisions).
Dmitriy