How to optimize loading and front-end search with google sheets?

Question

JavaScript

Hey!
At the front, I download and display a Google spreadsheet.
The problem is that the lines > 100k and there is a hang.
How can you optimize?

For example, how to download only 1000 rows instead of all?
But then the search turns out to search only for 1000 lines, and not for the entire table.

Sandbox here - https://jsfiddle.net/83L1wbm6/

Answer 1

Usually there is an api call, then the server searches for all the data you need and then the desired selection with a limit and offset is returned in response