Hey,

Been googling for info about this for a couple of hours, seems to be the ask-for-yourself-time now since I've found nothing on these subjects except for this old thread: http://drupal.org/node/92675

I have a functional Drupal installation with two sites under construction (more to come) on separate subdomains and access restrictions through the Domain access module. I haven't prefixed any tables yet, since they complicate and duplicate the overall structure and since I haven't had any need for them yet.

However, on my secondary site, the theme keeps disappearing randomly, and based on that other thread, the problem probably has to do with the shared cache tables. All instructions about multi-Drupals mention about the $db_prefix-variable, but none state whether it is possible to get along without any prefixes. There are still a lot of questions from people with this kind of structure, what are the guidelines with this issue? If prefixing is necessary, what are the minimum required prefixable tables? The ones mentioned in the following instructions? http://drupal.org/node/201673

Another thing. At some point, when there will be more sites, performance could become an issue. Of course the servers can be upgraded, mirrored etc. It would still be important to know if it matters performance-wise whether the node tables are shared or not in a situation where there will be around 10 000 nodes per site? What about other tables? Couldn't find any other benchmarking results than about Drupal in general.

Thanks in advance for any guidance.

Comments

mnordstrom’s picture

*push* :(