My problem ist related to this question. In order to get the basic statistics I need the total item count. However the basic LINQ query
(from t in Tickets select t).Count();
does take a considerable amount of time (5-10 seconds on my laptop-vm, depending on load). Are there quicker ways to get the count, or is this huge timespan caused by the lack of resources on my machine?