If we have an instance of SQL Server with 5 databases, is it a bad practice to do some cross-database calls to aggregate data in a stored procedure and expose it?
I would normally assume the service does the data aggregation not the stored procedure. Also cross database calls are creating tight coupling, without the possibility of scaling or moving each database individually.
What are the design patters saying in such a case?
Aucun commentaire:
Enregistrer un commentaire