using more than one database

[LordRogaine]

I have a site that uses php with mysql. The database uses many tables. Some of these tables are being used by very long and complicated queries. To speed things up in the site, does it make sense to use more than one database at a time, so that some of the tables will be free while there are heavy queries being made to tables on the other database of the site?

Thanks,
Lord Rogaine

[planetsim]

I doubt it will make much difference as Id say youd be still using the same MySQL so its going to be MySQL thats going to be really trying to cover the load. Id probably suggest not doing it, however I dont know how much traffic the site is getting what the Queries look like.