Actually the op was asking about efficiency. If the databases are on the same machine using mysql as he stated, then it is more efficient to have one connection to one database. If the data grows to the point that you can't keep it all on one machine then you can be more efficient by partitioning it into different databases on different machines.