TalkPHP - View Single Post

JaoudeStudios · 08-18-2009, 06:45 AM

Each idea has its own advantages. The biggest advantage of using different databases is if it gets really heavy/busy you could move each database to its own server, however the downside to having multiple databases is JOINs become slower and JOINs across different servers are not permitted in MySQL - unless using Federated tables but thats another story.

08-18-2009, 06:45 AM	#5 (permalink)
JaoudeStudios The Acquainted Join Date: Jul 2009 Location: Surrey Posts: 105 Thanks: 1	Each idea has its own advantages. The biggest advantage of using different databases is if it gets really heavy/busy you could move each database to its own server, however the downside to having multiple databases is JOINs become slower and JOINs across different servers are not permitted in MySQL - unless using Federated tables but thats another story. __________________ JaoudeStudios.com \| JaoudeStudios.com Forum \| JaoudeStudios.com Blog OpenSource is the road ahead...!