Slow mongo query on createUser

[rjdavid]

That looks like an easier route to take

[paulishca]

Use lower case emails fix

[ritwik1234]

Hi @kimar,

I am working on a pull request to solve this issue. But I don’t see any significant slowness while creating a new account, using the createUser method. Of course I didn’t try with 400k users. If possible can you share some screenshots of the slowness? It would be really helpful.

[jasongrishkoff]

My users collection has nearly a million documents now, which means that if someone tries to register with an email such as info@gmail.com it takes 20+ seconds to do this query. I see the Github pull requests all ended up getting skipped? So it seems like this is still an issue in 2022? Has anyone figured out an elegant solution?

[jkuester]

Would it be possible to implement the user creation without the need to perform the query (for example if a certain flag is passed as option to shut this off) and instead perform the query on our own? That would at least be non-breaking and allow those with performance needs to do the query in a performant manner.

[rjdavid]

Database performance of case-insensitive user lookups

We’ve been doing an analysis of our MongoDB Disk IOPS usage on Atlas, and many queries on the users collection seem to have a very high examined/returned ratio (sometimes in the thousands). I believe it’s due to the _selectorForFastCaseInsensitiveLookup function which constructs an unusual regex to try to speed up case-insensitive lookups by email. The result is that about 1/3 of the total disk IOPS from our slow queries seem to come from the users collection alone. Has anyone else run into thi…

[jasongrishkoff]

Thanks @rjdavid - I remember seeing that thread but couldn’t figure out what to search for. Seems like there isn’t a simple solution out there yet.