ra0o0f / arangoclient.net

ArangoDB .NET Client with LINQ support
Apache License 2.0
99 stars 37 forks source link

Query Slow #66

Closed francnuec closed 7 years ago

francnuec commented 7 years ago

I'm still testing this client. I'm using a .net core identity userstore as part of this test in a new project.

But I noticed this simple query call to the db on a collection which has just one document takes over 2 seconds to complete:

var user = Database.Query<TUser>().FirstOrDefault(x => x.UserName == userName);

Other similar queries in the UserStore also takes at least 2 seconds, taking the total time of logging in to a completely new asp.net core application to around 15 seconds +.

I downloaded the code for this client to dig deeper, and it seems the problem comes from the point where the HTTP request is made.

Is there a solution to this? It is currently too slow. By comparison, a MongoDB backed UserStore does the entire logging in in milliseconds. Please help.