Slow custom Person entity

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • item
    Active Community Member
    • Mar 2017
    • 1476
    #1

    Slow custom Person entity

    Hi,

    strange issue : I have create a custom entity "Person" template.
    I have just one custom field varchar. (4 relation many2many to Account/Contact/ X,Y ) no stream, no link multiple.
    I have 3500 record, and list view is very slow. (detail view and search is fast)
    I have removed all 4 relationship : same result, list view slow.
    (just firstName, lastName, address and one varchar field completed)

    I have create a custom entity "BasePlus" template.
    I have custom field varchar, address fields (4 relation many2many to Account/Contact/ X,Y ) no stream, no link multiple.

    I have put 10000record, and list view is fast !

    Is emailAddress or phoneNumber field do this issue ?
    20record/page, use cache, disabled display total count.

    esporcrm 5.5.6. (php 7.21 mysql 5.7.23 - 2,9 GHz Intel Core i7 16gb)

    Regards

    Edit :

    After put "email/phone" field via entityDef to my BasePlus entity ... this entity list view become very slow on list view !
    theses field email/phone are not on the list view layout
    Last edited by item; 02-18-2019, 03:25 PM. Reason: entity list view become very slow on list view with email/phone field
    If you could give the project a star on GitHub. EspoCrm believe our work truly deserves more recognition. Thanks.​
    Tags: None
    • item
      Active Community Member
      • Mar 2017
      • 1476
      #2
      it's seems to be when search bar is empty !
      same with "sort" by field.

      but if just a letter "a" or "b" in search .. it's more fast.

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

        Comment

        • yuri
          Member
          • Mar 2014
          • 8440
          #3
          In 5.6.0 it will be faster.
          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
              #4
              hello,
              just for my understood : why this don't happened with "contact/account" out-of-the box entity !?
              strange with custom entity... nothing special (no hook, no customisation, ...).

              I have too uninstalled advancedPack for see if .. but no, advancedPack is not the "coupable"
              Ok I have see "mysql have problem with join" .. but we only have 20 records on list view, no email/phone...

              Just for info : 4.5 secondes on "Google Chrome" for render 20 records in a table with 3000 record (with max 5 field completed )

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

                Comment

                • yuri
                  Member
                  • Mar 2014
                  • 8440
                  #5
                  I don't know. Tried a list view with email address and phone numbers, 4000 total: loaded in 1 second. Version 5.5.6.
                  Last edited by yuri; 02-19-2019, 09:03 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

                    • yuri
                      Member
                      • Mar 2014
                      • 8440
                      #6
                      Tested 240,000 records all with email addresses: 4 seconds. Windows, Maria DB.
                      Last edited by yuri; 02-19-2019, 09:04 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

                        • yuri
                          Member
                          • Mar 2014
                          • 8440
                          #7
                          Maybe you have bloated entity_email_address table?
                          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
                              #8
                              Yuri,
                              no... I have 100 account (max 2 email), 300 contact (each contact have max 2 email)..
                              I will try in a new instance.. and give feedback.
                              but what I don't understand.. Account/Contact very fast ...
                              new custom entity Person (without any email, any phone).. slow ..
                              And nothing in log file.. I have put "DEBUG" in config file and nothing..

                              Strange.. let me search what's happen but if you say me ..look there or there for help
                              Last edited by item; 02-19-2019, 09:45 PM.
                              If you could give the project a star on GitHub. EspoCrm believe our work truly deserves more recognition. Thanks.​

                                Comment

                                Previous template Next
                                Working...