I know this has been talked about and I’ve gotten good answers but I’m still concerned about making 1 giant database that will house different companies information in spot.
Do most of you that provide an app deploy a single database for each company or one giant app that has like a “site id” in each table? My concern is the amount of data in each table. I know MySQL is awesome but I’m afraid of corruption or so much information being accessible by accident.
If you are using 1 single large database, how do you secure it so well? I’m also planning on allowing Joomla to interface with my application, and I’m thinking that won’t work if its 1 large app, to be able to sync with each company’s Joomla users table…
The final question is, if you use assign a database to each client, how do you configure that in SC??? Just by hand? I find that so time consuming.
thanks!
Happy New Year!
Chris