I was testing Persistent Dictionary in the following scenario:
A dictionary with a couple of millions of records, with a simple structure as value (string Tag, string Cluster, int Count).
I wanted to make some hard-coded queries using Linq over that dictionary.
I have tested some simple queries (where(), count() over some of the properties of the structure value) and it takes several minutes. It is terribly slow.
using (var dict = new PersistentDictionary<string, UseStat>("EsentTestUseStatDb"))
clustered = dict.Count(x => x.Value.Cluster.Equals("3"));
I just wanted to check with you this is not a proper scenario for Persistent Dictionary, and that I should use "raw esent" in order to get some satisfactory performance.