Slow speed with pagination also, why?

hi there, quick question! I'm using pagination as per this docs: https://appwrite.io/docs/products/databases/pagination

now, and I'm loading only 5 docs per page, still it's taking too much time to load single page, even 1st page. why? i tried both offset & cursor based both takes time.

TL;DR

Developers are experiencing slow speed with pagination even when loading only 5 documents per page. A suggestion was made to add an ascending key index on the column 'name'. Additionally, clarifying questions were asked about the queries, the number of documents in the collection, and the location of the developer. They are using pagination according to Appwrite's documentation, but are still encountering delays.

What exactly are all your queries?
How many documents do you have in your collection?
Where are you located?

Queries:

TypeScript

Query.orderAsc("name"),
Query.limit(table.rowsPerPage), // table.rowsPerPage == 5
Query.cursorAfter(tableData[tableData.length - 1].$id), // using last doc's id