--- Timwi timwi@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