serious inserts/preformance problem

Jul 15, 2013 at 2:26 PM
Edited Jul 15, 2013 at 2:27 PM
hi

in order to optimize dbreeze in my application I ran few tests on it. After Reading the using article with dbreeze I realized that string keys much more slower then numerics for example.
So I preformed some test and for example if i run simple test on dbreeze like this:

using (var tran = engine.GetTransaction())
            {
                try
                {
                    //THIS IS FASTER 
                    for(int i=0;i<1000000;i++)
{
    tran.Insert<int,int>(“t1”,i,i)
}
tran.Commit();
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.ToString());
                }
            }
so in the first time it will run realy fast (when the table not exists and will be created), on the second time when it will run on the same table it will be much much slower, now with int its the most fast thing. I gonna use strings/hashes and it acts the same, for example db with 100000 ulong hash keys to insert take me on first time like 2 secs, on second time it takes 100 secs,.

is there anything i can do to solve this problem?

don.
Coordinator
Jul 15, 2013 at 7:53 PM
Edited Jul 15, 2013 at 7:53 PM
of course, read documentation
20130529 - Speeding up batch modifications (updates, random inserts) with Technical_SetTable_OverwriteIsNotAllowed instruction.