Does anyone have an idea of mongodb performance? I've been using mysql for years and im trying to determine if its more optimal to have more collections or more documents (referring to very large quantities of data) - in MySQL it is more optimal to have more rows than to accomodate for more tables.
For instance we can have two tables (collections) of hotels with customers or one table/collection that has an additional column containing the hotel.
Perhaps it could be more optimal because it makes a collection size smaller on disk (by having two collections instead of one) so its faster to query?