Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » multiple database performance
multiple database performance [message #3036] Fri, 02 May 2008 15:52
rlangham is currently offline 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:
  

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

Current Time: Sun Jul 5 15:32:29 EDT 2009

Total time taken to generate the page: 0.01768 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.