1C services implementation of paginated data output

Question

Database

I am writing a web project on .net that works with 1C database (MSSQL) through services. Is it possible to request in 1C not ALL the data in the lists, but only 20, and for example like this: skip 60, output 20. I don’t write in 1C myself, but if you write me approximately how to implement this, I will show the 1C programmer where to dig .
At the moment, the solution we have come to is: I connect directly from the program to the 1C database and make an SQL query in which I prescribe the necessary conditions.

Answer 1

Still simple (=

ВЫБРАТЬ ПЕРВЫЕ 20
  ЗаказКлиента.Ссылка
ИЗ
  Документ.ЗаказКлиента КАК ЗаказКлиента
ГДЕ
  НЕ ЗаказКлиента.Ссылка В ИЕРАРХИИ
        (ВЫБРАТЬ ПЕРВЫЕ 60
          ЗаказКлиента.Ссылка
        ИЗ
          Документ.ЗаказКлиента КАК ЗаказКлиента
        УПОРЯДОЧИТЬ ПО
          ЗаказКлиента.Дата)

УПОРЯДОЧИТЬ ПО
  ЗаказКлиента.Дата

Answer 2

I also did the same. those. I work directly with the MSSQL database, it is somehow faster, you just need to remember about the dates

Answer 3

What is the amount of data? Maybe make an updated cache in the form of an indexed collection on the 1C side (the obvious solution is the Value Table), and return data from it? Then, by indexes, you can make a selection using the usual for loop. But this will require a significant amount of memory on the 1C server (keep the cache in memory and update it).
You can go out, but it is also resource-intensive: kb.mista.ru/article.php?id=703