In Memory - what is the performance like ?

If you are curious as to what you gain by giving up FKEYS and Constraints ;) I have a layman's performance test which you can try yourself using the demo scripts I provided in my earlier post.

Here is what I see:

Table type	Action	Time Taken
Disk	Insert 20K Rows using T-SQL	18 secs
Disk	Insert 20K Rows using T-SQL Stored Procedure	18 secs
In-Memory	Insert 20K Rows using T-SQL	15 secs
In-Memory	Insert 1Million Rows using Native	3 secs

Pretty impressive!

Note: I did this on a VM using a 2 year old i3 laptop. I urge you to try this out and see what you get. I intend to do more tests using other scenarios in future