locked
Performance attaching files RRS feed

  • Question

  • Hi,

    Anybody knows if CRM maintains good performance if a lot of files are attached? What about 2 or 3 years adding files? It will be ok?

    Regards,
    Francisco
    Tuesday, July 21, 2009 8:36 AM

Answers


  • Hi Francisco,

    Microsoft CRM is designed to scale to meet the needs of an enterprise so importing files into the system should not be a problem. I have personally have migrated large amounts of file attachments (associated with account records) into MS CRM without any performance issues.

    If you are concerned about performance I would strongly recommend reading the performance and scalability white papers. (Please find link below).
    http://www.microsoft.com/downloads/details.aspx?FamilyId=5852B14A-394C-4898-8374-CAF5E6479EB0&displaylang=en

    I would also recommend setting up a test environment to test the performance after your document migration using the Performance toolkit. (Please find link below).
    http://blogs.msdn.com/crm/archive/2008/02/29/microsoft-dynamicstm-crm-4-0-performance-toolkit.aspx

    Please feel free to postback if you have questions about the above.

    Hassan.

    Hassan Hussain | http://hassanhussain.wordpress.com/
    Tuesday, July 21, 2009 12:59 PM

All replies


  • Hi Francisco,

    Microsoft CRM is designed to scale to meet the needs of an enterprise so importing files into the system should not be a problem. I have personally have migrated large amounts of file attachments (associated with account records) into MS CRM without any performance issues.

    If you are concerned about performance I would strongly recommend reading the performance and scalability white papers. (Please find link below).
    http://www.microsoft.com/downloads/details.aspx?FamilyId=5852B14A-394C-4898-8374-CAF5E6479EB0&displaylang=en

    I would also recommend setting up a test environment to test the performance after your document migration using the Performance toolkit. (Please find link below).
    http://blogs.msdn.com/crm/archive/2008/02/29/microsoft-dynamicstm-crm-4-0-performance-toolkit.aspx

    Please feel free to postback if you have questions about the above.

    Hassan.

    Hassan Hussain | http://hassanhussain.wordpress.com/
    Tuesday, July 21, 2009 12:59 PM
  • Hi

    I guess it will be also depend on your servers., we have almost 2000 files attached in one of our clients CRM. and the performance is still good.
    I guess because they have Good server configurations and multiserver deployment.

    Vilas http://www.mscrm-vilas.blogspot.com
    Thursday, July 23, 2009 10:20 PM
  • What do you mean by clients CRM? 2000 files in all the CRM database or inside an account? The server is nothing special...
    Friday, July 24, 2009 11:39 AM
  • I mean 2000 files as attachments in the CRM Database in one of our implementation.

    Vilas http://www.mscrm-vilas.blogspot.com
    Friday, July 24, 2009 10:27 PM
  • Definitely my boss doesn't want to have the files inside the database. Is there any way to configure CRM in order to save them outside it and having a link or something like this?
    Thursday, July 30, 2009 3:20 PM