Brion Vibber wrote:
On Feb 26, 2004, at 13:52, Timwi wrote:
Sure, it's possible to put a lot of effort into something that yields very little improvement, but, y'know, why?
Similarly: Why not? - seeing as I'm not going to help with the profiling either way, I might as well help with the database optimisation.
If you can add something to http://meta.wikipedia.org/wiki/Proposed_Database_Schema_Changes please do.
Hm. Looks okay for short-to-middle term. I suppose this suggestion is based on the thought of having to convert the current database easily. It doesn't account for several things we really really want to do in the middle-to-long term, such as combining all language Wikipedias in a single Wiki, so that people don't have to register hundreds of usernames, or more flexible handling of user properties and article properties.
The database schema I propsed last year: http://meta.wikipedia.org/wiki/Experimental_new_database_schema takes these into account, but is (obviously) a little dated by now. For example, it does not know about the MediaWiki namespace and how it now handles translatable site text.
Timwi