Bulk information in database

  • Is there any concerns on creating bulk information in database?

    Like customers, suppliers and items.

    Your partner who are implementing CRM here are trying to restrict on this.

  • Luqman

    You will need to explain a little more about the needs that you have.  What do you mean by 'creating' - do you mean inserting data in batch or high volume processing?  Is that a large number of users creating a large amount of data? Do you mean a one off action or a repeated action? Does the data exist in onther system? Do you need to create data in CRM or link to existing data sources?  And then what do you mean by bulk?  What data set size is that?  What number of records are you considering?


  • Dear Jeff,

    Fist of all thanks for your reply.The requirement is, we need to add large no. of products both active and inactive in which suppliers provide, we are traders of  value added electronic circuit, we do both service and sales as business, we had limited customers and suppliers but large no. of products(components).

    our product grouping is Product lines>>Product Group>>Product Family>>Part No.

    We had a large no. of Part No.s

    Thanks and Regards

    luqman@tecnomic.com

  • Luqman

    This is where the relationship with both you partner and the local Sage team is so important and they should be able to really spend the time understanding your requirements and your existing systems.

    Do you have an existing inventory control system?  Are the details of the components stored in an existing system?

    Do you really need to import the data into Sage CRM or do you need to have that data available to Sage CRM?

    Are you going to be raising Quotes and Orders in Sage CRM?


  • Dear Jeff,

    Q:Do you have an existing inventory control system?  Are the details of the components stored in an existing system?

    Ans: In excel sheets

    Q:Do you really need to import the data into Sage CRM or do you need to have that data available to Sage CRM?

    Ans: Yes

    Q:Are you going to be raising Quotes and Orders in Sage CRM?

    Ans: Yes

    ____________________

    I just want to know that can we add some 60000+ Part No. to the system?

    will it make the System slow?

    Thanks and Regards

    luqman@tecnomic.com

  • Luqman

    60,000 plus records in a single table would not cause a well tuned database any performance issues. Implementations Sage CRM can handle really very large amounts of data.

    There is plenty of information available to help you and your partner understand the Database server requirements for a Sage CRM implementation.

    As an examples please see

    Using the Database Tuning Advisor to Optimise CRM databases

    community.sagecrm.com/.../using-the-database-tuning-advisor-to-optimise-crm-databases.aspx

    Your business partner should have access to additional resources.  The following articles are in the partner only area of the system.

    Database Tuning : What is my SQL Server doing?

    community.sagecrm.com/.../database-tuning-what-is-my-sql-server-doing.aspx

    How much RAM do I need for my CRM database server?

    community.sagecrm.com/.../how-much-ram-do-i-need-for-my-crm-database-server.aspx

    SQL Server Tuning: Back to basics!

    community.sagecrm.com/.../sql-server-tuning-back-to-basics.aspx

    Your partner would have to work with you to model how the components would be stored in Sage CRM, and what would need to change in the existing Quote and Order area of Sage CRM.  This may need to have custom pages created (either using the .NET or COM APIs).


  • Hello Luqman

    This is Kannan from Sage India, you may want to email me any of the concerns you have with your current implementation? I understand that you are based in India. Request you to drop me an offline email at kannan.srinivasan@sage.com

    Regards

     

    Kannan Srinivasan

  • Dear Jeff, Kannan

    Thank you for your responses

    our issue resolved.

    Regards

    Luqman

  • Hi Jeff,

    I figured why not post on an article from 2011? I have client we are working with and specifically trying to come up with ways to improve database performance. The last three article links in your post above have been removed from the site. I understand as they probably have dated info in them. Do we have anything updated on this? Or, could we get to these "archived" articles? Just curious.

  • Are there any specific areas that are performing badly, such as communication, or is the whole system generally running slow?

    Sage CRM specialist and all round fan! Please feel free to follow me on twitter @dannycrm

  • - Alas those blog articles are long gone.  They were so old - they were talking about SQL Server when it was still powered by steam.