I am building a site on drupal 6 with numerous modules. It will be a small community site with events, forums, video, image galleries, blogs, etc.. I want to incorporate a crm (client relationship management) "back end" in to this. I am using a panels dashboard for the "back end" to track the clients profile info, (event appointment) node creation, comments, and communications.
My first question is what would be the best way to "store" the communication records. Right now I am thinking nodes, I can import emails, and document phone calls. This could add up quick with all the other node types. Maybe one node per client for all communications?
My next question is how to set this up for performance and security. All one site/one database? One site 2 databases? 2drupal installs (domain/clients) 2 databases? I was testing civicrm and read about some performance issues with prefixed taables in databases. I am not really sure how to do that anyway, civicrm does it (semi)automatically.
Any ideas or suggestions to either of these questions will be greatly appreciated.
Chris