I am looking at parts of my application to access data from two separate databases.
I am just wondering what sort of resources this uses as I am trying to understand it better.
There is only a small amount of data in the other database it needs to access. For system performance am I better to put the table and data into the one database? I would prefer not to double up the same data into two databases if I can, but am interested in the performance side, especially if I have a large number of users on this, as hoped.
I would appreciate advice from an expert on this.