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

_______________________________________________
Wikitech-l mailing list
Wikitech-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l

Reply via email to