How Manage DB and multi subsites for a website newspaper with million nodes?
Posted by jscm on January 25, 2011 at 1:18pm
Hi,
I have to choice how manage section of a large Newspaper Website.
I could choice to use only one DB to manage all but I will get 2 tables with large amount data (about nodes and search index) and great problems about queries optimizations for search index.
Read moreSingle signon without prefixing dbs?
Posted by paul_constantine on March 23, 2009 at 8:37am
Hello all,
I am runnung a small network of multilanguage Drupal 5.16 sites using a single codebase, separate databases and instead of sharing users across databases I use a seperate user database that is accessed by all websites. The user database contains the following tables (these tables were dropped from the other databases):
- authmap
- buddylist
- buddylist_buddy_group
- buddylist_groups
- buddylist_pending_requests
- facebook_status
- privatmsg
- privatmsg_archive
- privatmsg_block_user
- privatmsg_folder
- sequences
- sessions
- userpoints
- userpoints_txn