How to fetch document faster?

I wanna fetch a document where it checks if username == username then i want that document but it is taking around 1.2s and after indexing 1 or 1.1s

TL;DR

Developers are asking for help on how to fetch a document faster in Appwrite. They mention a response time of 1.2 seconds for getDocument and want to know how to improve it. The issue might be related to the Appwrite instance's average response time. One developer is confused about the appwrite instance and getDocument method. They mention that listDocument query is also taking 1.2 seconds. There are only 22 documents in the collection. A potential solution could be indexing to improve the fetch time.

result = databases.list_documents( database_id, collection_id, [Query.equal("username", "appwrite")] )

and the documents are only 22 in that collection

What's the response time for getDocument?

do you mean getDocument method>

well, im not using getDocument because it needs to be pass documentID

I know I just want to know what the baseline response time is.

What's your average response time to your appwrite instance?

its taking(1.2s):

result = databases.get_document( database_id, collection_id, document_id, )

appwrite instance??

what is that, can you bit explain it?

Whereever your appwrite is hosted, be it selfhosted or appwrite cloud

You can see that this is the time it takes appwrite for you to respond. That's why your listDocument query takes 1.2s. It can't get much faster than that

Are you using selfhosted or appwrite cloud

appwrite cloud

and where can i see or find " average response time" ?

I mean if it takes 1.2s for getDocument to respond then that is pretty much your response time

Where are you located?

India

Reply to this thread by joining our Discord

Reply on Discord