Possible performance degradation because of missing index on publicKeyCredentialId

[ruudk]

Description

I'm currently playing with this framework and noticed that the default table for the credentials does not set an index for the publicKeyCredentialId column.

Next to that, for MySQL it picks longtext. You cannot set an index on that either.

So this will be fine with a demo application, but as soon as this table grows bigger, performance will be degraded significantly.

Maybe a suggestion could be to hash the publicKeyCredentialId and use that to lookup the credential?

Example

No response

[Spomky]

Hi @ruudk,

Indeed, this field should have an index.
I created PR #670 for that, but I'm not sure if it's the right approach. I'll mention it in the documentation.