Announcement

Collapse
No announcement yet.

Investigation how speed EspoCRM

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Investigation how speed EspoCRM

    Hello,
    it's just my 2 cents discover... Yuri can correct me if i am bad.

    I know, recently ... a field where added or modified .. "createdAt"..
    then I see my custom entity created before this changement .. have this field but this field is not a "index".
    after search and so .. see print-screen of a tools ( tideways.io : nice tools but expansive for me) .. my conclusion is :
    by modifying entityDefs and add in my custom entity in "indexes":

    PHP Code:
    "createdAt": {
                
    "columns": ["createdAt""deleted"]
            }, 
    the list view is more fast.. see print-screen

    If I am bad, Yuri can correct me.

    PS : I don't use cache in this sample

    Regards



    Last edited by item; 11-18-2019, 03:33 PM.

  • #2
    Hi,

    Proper indexes should give a huge performance improvement. We need to document it. I suspect that the request with the index took so long (2s is a lot) because of COUNT query. It takes a lot of resources. You can disable total count calculation at Administration > Entity Manager > edit entity.

    Comment


    • #3
      Thanks Yuri,

      for 2sec, don't worry ... we have a problem with the VPS.

      on my private vps :
      - 10sec for SCRUD operations over 4 tables => 10sec for 1000 records
      on these VPS :
      - 4 minutes for same SCRUD .. imagine each month 150000 record.. we have time for drink many coffee
      The provider of the VPS investigate this, it's why tideways.io have been installed. I suspect HDD and not SSD but no other info.
      As you can see, we have a problem with sql on all CRUD request

      still need to update php from 7.2.x to 7.3.x and MariaDb too.

      Regards
      Attached Files
      Last edited by item; 11-18-2019, 11:05 PM.

      Comment


      • #4
        Hello,
        after change VPS to a new server with SSD :

        speed increase for 10000records SCRUD operation over 5 tables : 43minutes to 5 minutes.
        and tuning mysql/mariaDB config so : https://dba.stackexchange.com/questi...ffer-pool-size

        old vps was SAS drive.

        Regards

        Comment

        Working...
        X