Some basic ESENT performance measurements - ESE/ESENT Database Stuff - Site Home - MSDN Blogs

Some basic ESENT performance measurements - ESE/ESENT Database Stuff - Site Home - MSDN Blogs:

'via Blog this'

The Results 

I used 16MB logfiles with 8MB of log buffer and circular logging turned on. All the other system parameters were left at their defaults and the test program had a single thread. Each record had an 8 byte key and 32 bytes of data. My machine has 2 x 2.5 Ghz processors and a 7200RPM 320Gb SATA drive.

First the test inserted 1,000,000 records, one per transaction using JET_bitCommitLazyFlush so that committing a transaction didn't force the log records to disk (they are written when the log buffer fills up):        elapsed time: 14.243 seconds : 70,210 insertions per sec

Then one record was retrieved 1,000,00 times:
         elapsed time: 1.217 seconds : 821,693 retrieves per sec

All the records in the table were scanned by moving through the table with JetMove and retrieving each record:
        elapsed time: 3.151 seconds : 317,360 moves per sec

Finally the records were retrieved in random order using JetMakeKey and JetSeek:
        elapsed time: 19.984 seconds : 50,040 seeks per sec