[Wikipedia-l] Re: Phase IV, Wikibooks.org/.com and WikimediaFoundation.org/.com (was Wikis and uniformity)

[Anthere]

--- Timwi <timwi at gmx.net> wrote:
> Timwi wrote:
> 
> > However, I'm not convinced that this really
> matters. It would only have 
> > to search on the entire fulltext index if you
> actually wanted to search 
> > the entire table (an inter-language search). If
> you had an integer 
> > column that specifies the language of an article,
> and an index on that, 
> > then searching only the English text would be
> equal in speed to having a 
> > separate table for the English text.
> > 
> > At least this is how I understand it. Of course I
> may well be wrong. 
> > I'll ask a MySQL expert later on, when he's online
> :-)
> 
> I have asked my friend and he confirmed by
> suspicion.
> 
> If you have several large tables A, B, C, ... etc.
> with identical 
> columns and types (that could, for example, be the
> recentchanges tables 
> for the different languages), you can always combine
> them into a big 
> table with an extra (indexed) integer or other
> fixed-length column that 
> specifies what original table the row came from
> (i.e. what language it's 
> in), and it won't be any slower.
> 
> Greetings,
> Timwi

Should not this conversation be on wiki tech ?

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com