stssoft / stsdb4 Goto Github PK

Hi,
I came up with some tests of your database implementation and find out that every lookup operation performs really bad on big data.
It seems that nearly 40% of the time is taken by Task.Wait().

To check the performance you can easily extend your Getting-Started example by the following block:

            //lookup
            Console.WriteLine("Lookup...");
            sw.Reset();
            c = 0;
            using (IStorageEngine engine = STSdb.FromFile(FILE_NAME))
            {
                ITable<long, Tick> table = engine.OpenXTable<long, Tick>("table");
                //select all ids to be sure there is a match
                var ids = table.Select(kvp => kvp.Key).ToList();
                //loading keys is not part of measurement
                sw.Start();
                foreach (var id in ids) //table.Forward(), table.Backward()
                {
                    var data = table.Find(id);
                    //Console.WriteLine("{0} {1}", id, data);

                    c++;
                    if (c % 100000 == 0)
                        Console.WriteLine("Found {0} records", c);
                }
            }
            sw.Stop();
            Console.WriteLine("Lookup speed:{0} rec/sec", sw.GetSpeed(c));

Do you have any plans on increasing lookup performance?

ArgumentException: 'IsBlack' is not a member of type 'System.Collections.Generic.SortedSet1+Node[System.Collections.Generic.KeyValuePair2[STSdb4.Data.IData,STSdb4.Data.IData]]'

System.Linq.Expressions.Expression.PropertyOrField (System.Linq.Expressions.Expression expression, System.String propertyOrFieldName) [0x00000] in , line 0
TypeInitializationException: An exception was thrown by the type initializer for STSdb4.General.Extensions.SortedSetHelper`1

STSdb4.General.Collections.OrderedSet`2[STSdb4.Data.IData,STSdb4.Data.IData].TryGetValue (IData key, IData& value) [0x00000] in , line 0

Where is developer？

Hi,

Awesome library which a colleague and I discovered earlier today. We've been doing tests all day, and so far we're amazed.

Would it be possible for you to update the NuGet library hosted here (https://www.nuget.org/packages/STSdb/) ?

This library is quite old, being version 4.0.0 from 2013, where the newest in this repository seems to be 4.0.8 and from late 2015. It would make adoption easier, at least for my part :).

Regards,
Mike