
We are creating a multi vendor food delivery system and we want to create 3 databases. One database will have vendors profile, category, food and fav user food collections , database 2 will have cart item , discount, order and location collections and database 3: will have chat room, chat message support collections.
Is it efficient to do it this way or it does not matter ?

It really depends on how you can manage the internal logic and understand it.
Different Database is also fine as it gives more understanding and readability. Example -
- Database - Vendors └── Collections - Some logic based different collections or a single one to group vendors.
- Database - Misc [locations, etc.] └── Collections - same as above []
- Database - Chats └── Collections - different chat documents per chat room.
Another Database Logic - Database - Delivery App └── Collections - └── Vendors -> List all vendors └── Misc -> Add Coupons, Menus, etc
Database - Chats └── Collections - └── Chat-[VENDOR_ID-USER_ID] └── Chat Documents.

So it does not change the speed of the system
Recommended threads
- Query params are way too limiting in ter...
I was trying to list rows in a table that do not already exist in another table. I retrieved around 260 row IDs which are 13 characters in length each, and then...
- Relationship null, even when relationshi...
Hi Everyone, im experiencing issues with set relation data. When im setting the document id from the related database most of them seem fine, except one table. ...
- REQUEST FAILED IN MIGRATION
I was trying to moved my archived project to a self-host database . Though the Project is "read only" but there's a message that I can view and migrate data to...
