Record limit

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Mark
    Senior Member
    • Dec 2019
    • 143
    #1

    Record limit

    Hi,
    i wanted to ask if Espocrm would work fine if there were 15 million records as products and there would be other added functionality (through workflows, etc.) related with those products in the system?
    Tags: None
    • emillod
      Active Community Member
      • Apr 2017
      • 1405
      #2
      I think it's worth of trying. I saw instances with 1 million of emails and everything there was working ok.
      You just need to invest in good server...

        Comment

        • item
          Active Community Member
          • Mar 2017
          • 1476
          #3
          I confirm emillod
          you can't have good result with bad server !
          forget : hdd sata .. ssd is the minimum and sas ssd is the best i think but no have experiment about

          As Yuri say... the problem is "database" (i resume) .. index ..
          we have actually 6224973 record in one entity.. on ssd .. it's acceptable.. because we use ssd with 4gb ram server and only 3 users

          Last edited by item; 10-06-2020, 07:31 PM.
          If you could give the project a star on GitHub. EspoCrm believe our work truly deserves more recognition. Thanks.​

            Comment

            • yuri
              Member
              • Mar 2014
              • 8453
              #4
              The bottleneck is filtering records by many-to-many relationship, e.g. filtering by Teams. If you don't need to limit access to products by teams, 15 mils should not be an issue if your server is good enough. You might also need to setup additional indexes before populating your database. Also disabling Total Count on the list view is recommended. See https://docs.espocrm.com/administrat...ance-tweaking/
              Last edited by yuri; 10-06-2020, 07:35 PM.
              If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                Comment

                • item
                  Active Community Member
                  • Mar 2017
                  • 1476
                  #5
                  Hello Yuri,
                  if you think : we need role, we need teams, we need stream, we need action history.. we need ..
                  a CRM need a best server.. with all speed...
                  espoCRM respond to requirement of "users".. we need to find a "server" who respond to that

                  Regards
                  If you could give the project a star on GitHub. EspoCrm believe our work truly deserves more recognition. Thanks.​

                    Comment

                    • emillod
                      Active Community Member
                      • Apr 2017
                      • 1405
                      #6
                      Yeah guys, i think here is more important server than EspoCRM, because users have similar issues with woocommerce, they're worried about large amount of products but woocommerce can even handle 36 millions of products(there is real example which i saw!), but application is not a problem. The most important thing is good server which will handle for example big amount of requests to database.

                        Comment

                        • Mark
                          Senior Member
                          • Dec 2019
                          • 143
                          #7
                          Thank you for the answers!

                            Comment

                            Previous template Next
                            Working...