Loading large amounts of data (pagination)

Question
#1

Good morning,

via REST API, I download a large number of articles from my database (MySQL). It takes a few minutes to load them all at once, so I would like to know how to add pagination or at least a “Show more” button or infinite scrolling.

I have already looked through dozens of pages and nowhere have I found step-by-step instructions on how to do something like this.

Please help.

#2

Hi! For pagination in queries, you have to check what your backend supports. There are usually some type of query parameters you can pass to paginate, and you could then configure those for your rest API resource.

1 Like
#3

Do you know clauses SQL?

Use select with offset, limit