Fastest Way to Retrieve Events from AF

I am anxious to see this through.  We are always looking for successful cases, particularly with lightweight searches.  For the fields definition, anything that is an event frame property should be written with the proper name and NO |.  Anything that is an attribute must contain a |.

I came up with my own version of GridEvent.  This may be thought of a DTO (Data Transfer Object) or a POCO (Plain Old Class Object).  Note I include the Event Frame ID, just in case you ever need to find the source event frame.

  public class GridEvent
    {
        public string Name { get; set; }
        public AFTime StartDate { get; set; }
        public AFTime EndDate { get; set; }
        public double Duration { get; set; }
        public string Reason { get; set; }
        public string[] ChangeHistory { get; set; }
        public string Comment { get; set; }
        public bool Locked { get; set; }
        public Guid EventFrameID { get; set; }  // for more direct link back to source Event Frame
    }

Then I have this method to drive it all.  Note I have not tested this but the code compiles correctly.

      public void LightWeightSearch(AFDatabase afDatabase)
        {
            var eventTemplate = afDatabase.ElementTemplates["Chimiwungo Down"];

            string query = $"Template:'{eventTemplate.GetPath(afDatabase)}'";

            List<GridEvent> geList = new List<GridEvent>();

            // In fairness, to measure the time for the AFEventFrameSearch, you should limit the stopwatch to the search
            // itself.
            Stopwatch sw = Stopwatch.StartNew();

            using (var search = new AFEventFrameSearch(afDatabase, "*", AFSearchMode.Overlapped, new AFTime("2018-01-01"), new AFTime("2019-03-13"), query))
            {
                // Opt-in to server-side caching
                search.CacheTimeout = TimeSpan.FromMinutes(10);

                // The order of these fields determines the order of returned values in IList<object> below.
                // Attributes require a preceding | and anything with an embedded blank needs to be wrapped in quotes.
                // Attributes are returned as AFValue.
                var fields = "Name StartTime EndTime Duration |Reason '|Change History' |Comment |Locked ID";

                //Define your custom factory to map back to your class
                Func<IList<object>, GridEvent> factory = (values) =>
                {
                    // The values[index] correspond to order in variable "fields"
                    var dto = new GridEvent();
                    dto.Name = (string)values[0];
                    // if you wanted to use DateTime, change to: = ((AFTime)values[1]).LocalTime;  // Or .UtcTime
                    dto.StartDate = (AFTime)values[1];
                    dto.EndDate = (AFTime)values[2];
                    dto.Duration = ((AFTimeSpan)values[3]).ToTimeSpan().TotalHours;
                    dto.Reason = ((AFValue)values[4]).Value.ToString();
                    dto.ChangeHistory = ((AFValue)values[5]).Value as string[];
                    dto.Comment = ((AFValue)values[6]).Value.ToString();
                    dto.Locked = (bool)(((AFValue)values[7]).Value);
                    dto.EventFrameID = (Guid)values[8];
                    return dto;
                };

                var geRecords = search.FindObjectFields(fields, factory);

                foreach (var geRecord in geRecords)
                {
                    geList.Add(geRecord);
                }
            }

            sw.Stop();

            // Time to sort this is done outside of the AFSearch.
            // With roughly 3000 items, it should be fast with low memory consumption.
            geList = geList.OrderBy(x => x.StartDate).ToList();

            Console.WriteLine(sw.ElapsedMilliseconds / 1000.0);
            Console.WriteLine(geList.Count);
            Console.ReadLine();
        }

Give that a try.  Let me know what does or doesn't work.