slowly

[peterberlin]

Hi,
We have approximately 13,000 addresses in the Accounts. So far, the search quickly. Since 4.0.6, the system is very slow.
Peter

[yuri]

Hi,

What exactly is slow? Please more precise. When you search? By what fields?

[yuri]

Now it searches in emailAddress as well. That could be the cause. See https://github.com/espocrm/espocrm/c...8867ecd490dd08
If you remove "emailAddress" and clear cache it will work as before.
"textFilterFields": ["name"]

[peterberlin]

if we are looking for the name of a company, it takes 3..4 times as long as before.
examples:
- In the list
- When you create a meeting

[yuri]

Do you use wide text input when search? Please read my previous comment.

[peterberlin]

No.
Example: AVM
Or
3Q

Global search is fast

[yuri]

Just tested, can't observe the difference. Search by email/phone now is much faster. Search by name we didn't touch, don't think it could be affected.

[peterberlin]

If we are looking for a company to name phone number or email it takes now always very long.
The search takes 4 to 5 seconds.

[yuri]

If you search only by phone number by adding Fields > Phone filter and leaving main text filter empty does it takes long?

[peterberlin]

then fast

[peterberlin]

We have to test the 4:04 back secured. ESPO running very fast. Then we have updated to the 4:05. Since the system is slow.
Otherwise, we have not changed anything.

[yuri]

"Since the system is slow"
What actions exactly are slow? Please be more precise in description.

I try the instance w/ 26,000 contacts and don't observe problems with performance.

[peterberlin]

Sorry. I meant the search for the company.

The search in the contacts is also fast with us. Only the companies that are the problem.

[yuri]

Did you try cancel this https://github.com/espocrm/espocrm/c...8867ecd490dd08

Remove "textFilterFields": [] ....
Clear Cache

This must work out.

[yuri]

In the next version it will be configurable through UI.