[Mediawiki-l] Is there any reason to use a table name prefixifyou don't have to?

[Jack Eapen C]

Hi,

I suppose the original question was  not based on such a situation. He
(Gadget Doctor) hasn't mentioned about multiple wiki projects in his
installation. So, simple answer was he can do away with the table
prefix. Even if he wants to add more projects later, he can add prefixes
to the new tables. 

Another point- you mentioned that "Mediawiki has 136 separate tables
per-install". But in my MW 1.11, I can see only around 50 tables. Am I
missing something?


Regards,
 
Jack
----------------------------------------------------------------
"May He protect us both. May He cause us both to enjoy.May we exert
together. May our studies become brilliant. May we not hate each other"


-----Original Message-----
From: mediawiki-l-bounces at lists.wikimedia.org
[mailto:mediawiki-l-bounces at lists.wikimedia.org] On Behalf Of David A.
Desrosiers
Sent: Tuesday, February 05, 2008 7:24 PM
To: MediaWiki announcements and site admin list
Subject: Re: [Mediawiki-l] Is there any reason to use a table name
prefixifyou don't have to?

On Tue, 2008-02-05 at 19:07 +0530, Jack Eapen C wrote:
> Even if you use same database for multiple applications, it's not 
> necessary to use a table prefix. A table prefix will only help you 
> while viewing the table names-if you use a prefix, you can see all the

> mediawiki tables together.

Not quite. Mediawiki has 136 separate tables per-install. If you wanted
to use a single-database solution (which certain types of MW install are
easier to manage in this fashion), your only option is to use table
prefixes.

In my particular case [ http://projects.plkr.org/encycloplucker/ ], I
have 9 langauges against 6 wiki projects (books, news, quote, source,
etc.) in one database for ease of management (rapid import/export
operations). 

This brings the total number of tables to a whopping 7,344 if I import
them all at once (54 wikis * 136 tables in each). 

Without using 54 separate databases (functionally not possible in this
case, because I'm using just one instance of the Mediawiki source to
host all of these wikis), how do you propose a solution that does not
involve table prefixes?


--
David A. Desrosiers
desrod at gnu-designs.com
Skype...: 860-967-3820


_______________________________________________
MediaWiki-l mailing list
MediaWiki-l at lists.wikimedia.org
http://lists.wikimedia.org/mailman/listinfo/mediawiki-l


This electronic mail (including any attachment thereto) may be confidential and privileged and is intended only for the individual or entity named above. Any unauthorized use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. Accordingly, if you are not the intended recipient, please notify the sender by replying to this email immediately and delete this email (and any attachment thereto) from your computer system...Thank You