Performance questions about dbreeze HOT 2 CLOSED

Hi,

1. SelectForward or SelectBackward (doesn't matter)
2. I don't understand "serializing & deserializing again and again", if you like - store only byte[] and make your own serializations.
3. tran.RemoveKey is the only way to delete record from the table, if you want to cut piece of data from the file you have to copy valid values to other table (Select from table1 and insert into table2), then delete completely table1 and rename table2 -> table1.
4. Hold your batch inserts sorted (for traditional DBreeze, for object DBreeze it's included in the box) - the rest is already optimized, the only thing you can decide is either you want in concrete transaction faster update or not. In automatic updates, probably it doesn't matter, but for human interactions, when the huge batch is updated, it's possible you find that speed is not satisfactory and then you turn on "OverwriteIsNotAllowed" flag and get very fast updates paying a bit of disc space.
5. ObjectGetNewIdentity is very fast in batch (because it selects and then inserts only once per transaction). Under the hood it reads (Select) from the table, increments and inserts into the table. This is done for the object DBreeze. Object DBreeze is a layer on top of traditional DBreeze making easier procedures of working with secondary indexes.

from dbreeze.

Please, open it if you have more questions.

from dbreeze.