I have a site that is geting quite large and needs reorganising.
Instead of using one database with multiple tables with prefixes such as user_, directory_, events_, tracking_ etc. I was thinking of using multiple databases and place all the tables required for that function into that database.
This would mean multiple connections:
$conn_users = mysql_connect('localhost',$user_users,$pass_users);
$conn_track = mysql_connect('localhost',$user_tracker,$pass_tracker,TRUE);
$conn_dir = mysql_connect('localhost',$user_directory,$pass_directory,TRUE);
$conn_events = mysql_connect('localhost',$user_events,$pass_events,TRUE);
I was just wondering if using multiple databases and connections this way will create performance or memory issues.