Consider introducing limit for long queries

[Arjentix]

@arndey suggested to intorduce the limit feature, so that there will be a way to limit execution of long queries (i.e. FindAllAssets requires 3 nested loops).

@appetrosyan , suggested to use lazy evaluation, wsv clonning and paggination to implement this.

[Arjentix]

According to @arndey , 50k assets search takes 10s on local machine

[mversic]

possible duplicate of #3347

[appetrosyan]

One potential solution is to introduce re-entrant pagination and default to returning a reasonably paginated lazily evaluated result.

[Mingela]

Agree to solve the issue implementing a pagination and close this one in favor of that one