Slow custom Person entity

[item]

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

[item]

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 ?

[yuri]

In 5.6.0 it will be faster.

[item]

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

[yuri]

I don't know. Tried a list view with email address and phone numbers, 4000 total: loaded in 1 second. Version 5.5.6.

[yuri]

Tested 240,000 records all with email addresses: 4 seconds. Windows, Maria DB.

[yuri]

Maybe you have bloated entity_email_address table?

[item]

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