Two questions: 1. Does the # of tables in a db affect the performance? 2. Is it possible to "replicate" or "link" tables from 1 db to another?... [table] [tr] [td][b]DB: core[/b][/td] [td][b]DB: app1[/b][/td] [td][b]DB: app2[/b][/td] [/tr] [tr] [td]Table: users (id,username)[/td] [td]Table: albums (id,user_id,name)[/td] [td]Table: messages (id,user_id,name)[/td] [/tr] [/table] Is there any way to setup mysql to "link" from core.users so the table is also available in app1 and app2 db? I see there is replication but I am not sure that is what I want and that takes a lot of configuration. USE app1; SELECT * FROM albums LEFT JOIN users ON (users.id=albums.user_id) or will it always have to be SELECT * FROM app1.albums LEFT JOIN core.users ON (core.users.id=app1.albums.user_id)