Slow upload

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tutopoti
    Junior Member
    • Mar 2023
    • 4

    Slow upload

    Hello guys.
    I am trying to upload excel or csv files with more than 50000 leads but it take more than 1 hour to upload and the same amount of time to delete them.
    any suggestion how to make it fast?
    my server parameters are: cpu 4 core(8 thread) 8 Gb RAM and ssd 256GB.
    Thank You.
  • yuri
    Member
    • Mar 2014
    • 8442

    #2
    Hi, Do you mean that import is processed slowly? Make sure you run import in idle and in Silent mode (two checkboxes). You can also Skip checking for duplicates, that will improve performance.

    50,000 leads should be imported in the matted of a few minutes.
    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

    • tutopoti
      Junior Member
      • Mar 2023
      • 4

      #3
      Hello.
      Thank You for your response.

      Yes the import process is very slow.
      I am runing in idle,silent and skip for duplicates.
      I made also some mysql tuning and the perfomance is a little bit better but takes a lot of time to import and delete also

      Comment

      • tutopoti
        Junior Member
        • Mar 2023
        • 4

        #4
        in a list with 4 or max 5 columns (first name ,last name ,phone number ,email address, address) at maximum 10 leads can be loaded every second

        Comment

        • tutopoti
          Junior Member
          • Mar 2023
          • 4

          #5
          hello.
          any suggestion?

          Comment

          • esforim
            Active Community Member
            • Jan 2020
            • 2204

            #6
            I can only suggest to delete a few column to see if any of them make it fast or faster... when slowly figure out which field is causing the delay/slowness and import that separately.

            Not an ideal solution though... sorry.

            Comment

            Working...