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.

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

1. Queries:

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

2. 32 Documents
3. India

I'm on pro plan with appwrite cloud.

And how long does this take?

Can you try adding an ascending key index on name?

14-16 secs