What’s the most efficient MongoDB schema design for handling restaurant data with nested menus, categories, and dynamic pricing in a food delivery app?

[steevej (Steeve Juneau)]

You already had an answer to a similar question but did not have the decency to followup yet.

How can MongoDB be used to manage dynamic menus and daily food truck specials on a website?

Hi @Suheb_Multani, this question seems a bit open-minded, there are other factors to consider but how I would think around it would be to create documents daily in a collection, every year leads to 366 documents max, this ensures it can scale easily, you can also decide to delete older documents if they are no longer relevant. Each document can then represent the menu & special offers for that day. This model assumes that everything is always dynamic and is going to change which might not be th…