4 ms·
But I’d argue Monoliths don’t have anything inherent to them which makes reporting easier. A proper BI setup requires a lot of hard work no matter how the backe
by jsjohnst 7y ago
But I’d argue Monoliths don’t have anything inherent to them which makes reporting easier. A proper BI setup requires a lot of hard work no matter how the backend services are built.
- BrentOzar 7y ago> But I’d argue Monoliths don’t have anything inherent to them which makes reporting easier. It's easier to join tables in databases that live on a single server, in a single database platform, than it is to connect to lots of different data sources that live in different servers, possibly even in different locations (like cloud vs on-premises, and hybrids.)
- jsjohnst 7y ago> It's easier to join tables in databases that live on a single server, in a single database platform 1) what if your data set is larger than you can practically handle in a single DB instance? 2) nothing about a monolith implies you have a single data platform, let alone a single DB instance
- BrentOzar 7y ago> 1) what if your data set is larger than you can practically handle in a single DB instance? I have clients at 10TB-100TB in a single SQL Server. It ain't a fun place to be, but it's doable.
- jaxn 7y agoMonoliths have an advantage up until the point where you have to shard the database in some way.