Ayende Rahien

I may end up with a lot of dictionaries, yes. Note that I tested this on multi GB data sets (with millions of files). I end us with less than...

If you switch the SpatialContext to NtsSpatialContext it is still showing the same behavior

I'm also seeing something similar.

Looking into this

For `Sum`, you can do: `session.Query().GroupBy(x=>x.Country).Select(g => new { Country = g.Key, Points = g.Sum(x=>x.Points)) });` And that would also work with async enumerable.

Your query is wrong. You are asking to get the count of the results of the query, or the aggregated count per group by? You are also trying to do...

The way to handle that is to use a map/reduce index, something like: ``` // map from e in docs.Events select new { e.OrganizationId, e.HappenedAt.Date, e.UserId, e.TotalDuration // seconds }...

Having unsigned would make things a lot better, yes.

I'm usually working with `uint64`, so that is a really bad limitation.

For reference, the issue is different: https://github.com/ravendb/ravendb/discussions/18439