Timeline for Advice: Should i use multiple physical databases or one physical database and several logical ones
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 9 at 0:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 10 at 15:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 12 at 12:05 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 23, 2023 at 9:29 | answer | added | Francesco Mantovani | timeline score: 0 | |
| Jan 22, 2023 at 22:29 | answer | added | RolandoMySQLDBA | timeline score: 0 | |
| Jan 22, 2023 at 20:03 | comment | added | bane | @RickJames I'm just asking if it's wise for each company to have its own database or for all of them to be in one database, the databases would be created dynamically as new companies are added. | |
| Jan 22, 2023 at 16:55 | comment | added | Rick James | Are you controlling the apps? If so, one database. If they are building their own apps, then give them control by giving each a database and permissions only to that database. As for search, let's see the queries -- sounds like a "composite" index might fix the performance. | |
| Jan 22, 2023 at 14:35 | comment | added | Rohit Gupta | You have answered your question. If you want separation then use different databases. The down side is that any schema changes will have to be applied to each database. | |
| S Jan 22, 2023 at 14:30 | review | First questions | |||
| Jan 22, 2023 at 14:34 | |||||
| S Jan 22, 2023 at 14:30 | history | asked | bane | CC BY-SA 4.0 |