For smaller sites usually one database is quicker and for larger databases the time saved with tables being in the same database is negated so its best to have them in separate databases since smaller trimmer databases would load faster than one massive database.