2 Replies Latest reply on Mar 6, 2011 9:22 PM by RickWhitelaw

    best practices on one v. multiple files?



      best practices on one v. multiple files?


      Is there a good reason to choose to have all data in one file, or to make several files? In my case size is not going to be the determinant, just thinking through the organizational philosophy.

      In recruitment, [broad strokes here] I have records on People, Companies, Projects, and Actions. People are linked to Companies; Projects are linked to Companies (client), People (candidates) and Actions related to the project; Actions - email, telecons, research, advertising etc - link to  Projects, People, and/ or Companies. Reports might include actions taken on a project, actions on behalf of a client, actions to follow up on people or projects. 

      Just wondering about pros and cons of putting it all in one file or if there is advice to separate the parts.am I over thinking this?

      thanks, margot

        • 1. Re: best practices on one v. multiple files?

          In most cases it is simply easier to put all of your data into one file.  There are very few disadvantages to this and it generally makes developing and maintaining your solution easier.  Their are advanced techniques that can be used when separating your data into multiple files.  One example is using multiple files to separate the UI from the data.  Another would be if you where to develop an add on module that you wanted to lock down but allow it to integrate into other databases.  NGRShip uses this approach for its UPS and FedEx Shipping addons. 


          • 2. Re: best practices on one v. multiple files?

            Having developed a multi-file solution for my business over the last few years, I would say that given there is no limitation on the number of tables created in a single file, that the single-file approach is probably the way to go. One reason is the relationship graph gets complicated (duplication) with multiple files. On the other hand, if a solution is purposed to be modular (as is my current project) then the multi-file approach can make sense. Overall I say single-file.