MongoDB is this great database I hear about. I'd like to evaluate its performance in typical scenarios relatively to traditional MySQL or SQL Server backends.
Assuming I would like to store data about employees in many company divisions:
In MySQL we would store a table containing divisions, and another containing employees and then link them.
In MongoDB, if we used a design where we have a document for each division containing employees within it, how would this scale with many employees? Is this an efficient structure for a database? Does MongoDB offer benefits performance-wise (I love that we can store bits of data without a traditional column)?