* Bryan Tong Minh bryan.tongminh@gmail.com [Thu, 2 Dec 2010 19:38:47 +0100]:
On Thu, Dec 2, 2010 at 6:23 PM, Dmitriy Sintsov questpc@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