MySQL Performance: MySQL => multiple database performance

Members

Help

Home

Home » Performance » MySQL » multiple database performance

Show: Today's Messages :: Show Polls :: Message Navigator

multiple database performance [message #3036]

Fri, 02 May 2008 15:52

rlangham
Messages: 1
Registered: May 2008

Junior Member

Generally, how does performance of queries across multiple databases compare to a query on many tables in the same database? We are considering creating a separate database with its own tables that logically should be separate, but at times we will need to run a query (with joins) across the two databases. Is there a big performance hit for this?

Thanks,
Ron

Report message to a moderator

Previous Topic:	too many locked tables
Next Topic:	What limits Binlog_cache_use

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Tue Oct 7 17:34:34 EDT 2008

Total time taken to generate the page: 0.01329 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.