control multiple sites within one instance
I have many single page sites, each have their own Database, Do you think it feasible to have just a single data base
ie
Table with systemID
mrt relationship between systemid and page
I have many single page sites, each have their own Database, Do you think it feasible to have just a single data base
ie
Table with systemID
mrt relationship between systemid and page
Yes. I don't know your server configuration, but that should be possible.
Multiple sites relying on one database is pretty simple.
For instance, I have this site: https://retailertoolkit.com/ which serves Real Estate websites with their Listings but also Hotel Reservation Bookings.
Couple things to consider, do you have "other people" that have access to Insert routines? If so, you may want to consider additional security like multiple access Connections. This allows you to shut down that connection if someones local computer gets compromised.
Additionally, use a History table in your DB that logs IP address and what account is being accessed... I don't know what you are doing other than multiple sites from one DB but IF other people will have access, take the time to create ways to track if someone gets compromised.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.