Page navigation and GetList. GetList immediately selects all the data or the query is executed when you first call Fetch ()?

Question

The question of how sampling works in Bitrix. First, GetList selects ALL of the data, and NavStart already allows you to get a specific page? Or does GetList simply prepare the request, and the fetch itself occurs when the first call to Fetch ()?

I would be grateful if you indicate where you can read about it.

Thank.

Mihanik71 Mihanik71 3,200 12 32 · Answer 1 · 2016-08-05T08:17:54

GetList is an access to the database by parameters, and the 4 parameter arNavStartParams this function allows you to limit the selection according to the current page-by-page navigation.

In GetList we get extra data that we don’t get - they are filtered by the number, current page, etc.

And if we call GetList, and in NavStartParams we pass only the page size, will the sample select all records or not?
As far as I can see, when we call GetList, mysql_query is already running.
That is, if we do not set the GetList function, as you said, the data on which page we select, the entire amount of data will be selected.
GetList () turns out with the iNumPage parameter better than GetList with the empty parameter arNavStartParams and then separately called NavStart ().

Page navigation and GetList. GetList immediately selects all the data or the query is executed when you first call Fetch ()?

1 answer 1

More articles: