https://bugzilla.wikimedia.org/show_bug.cgi?id=20186


Tim Starling <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]




--- Comment #15 from Tim Starling <[email protected]>  2009-12-23 
08:45:11 UTC ---
The alternative to adding an index is to split the rev_deleted field out to a
separate "revision_props" table. This table would presumably be far smaller
than the revision table, since most revisions would not have any special
properties. Then you could put indexes on the new table without adding many
gigabytes to the core DB size. 

The table could even be added as a cache, similar to the links tables. Then the
existing read code would continue to work, you'd just have to fix the write
code.


-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to