- Use HammerDB to create TPC-H Database with Scale Factor 1 test DB.
- Create the memory optimize table
Insert 1500000 record to the disk space table takes longer than memory optimized table. Disk base table not only needs to scan the source table but also the target table.
LOP_HK is the new log type for in memory OLTP. HK stands for hekaton .
LOP_LOCK_XACT means the transaction also needs to hold the lock on the table.
LOP_INSERT_ROWShas twice as the row number because the additional index we have on the table.
When insert into the memory optimized table, we can see the memory utilization is increasing .