To be completely honest, in the past all I have really worked with was multiple tables within a single database.
However, all things come to an end and such is the case. I am about to begin a project (labor of love) for the office where I work. The site itself is going to be quite complex and I would like to break it into the best (and most efficient parts) as possible.
So my question is, with the following in mind, what is the smartest way to tackle the database design - tables within a db or multiple dbs?
I am going to need the following (tables or databases) to store information:
1) Client login information (and client info)
2) page text
5) companies (with ratings etc)
2) quote information
3) requests (store in db, no email)
5) claim info
Obviously, some of these could easily be incorporated into a single db and the queries could be sent using a join to maximize efficiency.
- Is it smart to completely split the front-end and back-end dbs?
- Would it be a complete resource hog to have only one db with many tables?
- Would it be a greater security risk to implement the previous statement?
- Is it more difficult (less efficient) to access info from two databases on a single page (if necessary)?
- Any other suggestions?
*For security purposes, all information is going to be passed via 256-bit SSL (pending browser supports - 128-bit otherwise).*
All comments & suggestions are no doubt going to be useful as I tackle this "bear."
To get an idea of how the information is going to be implemented - check out http://www.marianoagency.com/new for the template (work in progress). As mentioned, though, it is going to be pretty substantial once all is said and done so any "help" is absolutely appreciated.