J
J
JastaFly2021-07-12 12:41:21
1C-Bitrix
JastaFly, 2021-07-12 12:41:21

Bitrix slows down the category?

Good day to all! The site slows down the category with a large number of products. Yandex swears at the long server response. This particular category in terms of the number of products on the site is perhaps the largest on the site (50 thousand products if I'm not mistaken).
The catalog.section component is responsible for loading the elements. I do not like that it pulls a bunch of extra information from the database, for example, the same detailed text that is not needed on this page. Is there any way to filter these fields?!??
In general, at first I thought that the component somehow crookedly makes a request to the database and therefore the server starts to get dumb, but when I dug to the very bottom I realized that everything seems to be ok, exactly the number of elements that need to be displayed on the page come from the database, except perhaps a lot of extra data (which I mentioned above).
Now I think that the matter is in the paginator and it somehow loads the server in order to calculate the size of the pagination.
But in general, maybe someone has encountered Bitrix brakes in large categories?!?? What is the best way to solve them??!?
Thank you all in advance)

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
Ilya, 2021-07-12
@JastaFly

Turn on the profiler, see which queries are running for a long time and start from this in the issue of optimization.

The catalog.section component is responsible for loading the elements. I do not like that it pulls a bunch of extra information from the database, for example, the same detailed text that is not needed on this page. Is there any way to filter these fields?!??

Copy the component with the template and customize as you need, once you find out what the problem is. That's just DETAIL_TEXT is unlikely to greatly affect the speed of the request (you do not store "war and peace" there?)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question