7 replies

Is querying by indexed custom ID as fast as querying by Convex's internal _id?

In my Convex database, I have a couple tables that have a custom unique

provider_id

provider_id

that comes from an external service I sync with.

I frequently need to query by

provider_id

provider_id

in both actions and frontend code.

My question: If I create an index on

provider_id

provider_id

, will queries using it (e.g. getting the unique document identified by

provider_id

provider_id

) perform just as fast as queries using the internal

_id

_id

? Or does Convex have special optimizations for

_id

_id

that make it faster than any other indexed field?